SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I want to do the inverse of this post. What do I need to type in my excel field to automatically create a Choice column in SharePoint with multi values when importing the Excel file via the Import Spreadsheet App.
a;#b and a,#b
do not work.
Thanks! Fabian
I don't think that's supported by the import spreadsheet wizard. PowerShell can certainly do this, though that's a bit of a different skill set. Another option that may work for you is documented here, which involves setting up a workflow to update the multi-value field.
