Hello,
I have been recently working on a skills directory for my organization and have been running into a minor issue. I have 3 choice columns (Other Language, Skills/Proficiencies, & Certifications) which all allow for multiple selections. I have figured a way to automate creating the list items with my excel data in my table, but on multiple entries say for example "Other Languages", they can note down in the spreadsheet "Spanish, Russian", but in my SharePoint list instead of showing up as two separate choices they are grouped together in one choice "Spanish, Russian". This is the same for all of my columns as people have entered in multiple values for each category. I have been trying to look for a way to automate this flow when it creates these items to separate the array by a ', ' but again having no luck. Does anyone have any tips on how I can create a flow that will separate all three columns by a comma and create individual choices in the choices column in SharePoint? So far I have found a way to split the array but I can only figure out how to split one of the 3 columns out.
Current Flow:
in the 1st scope, I am pulling the list and deleting all items. Next I am Pulling the date from excel. In "Apply to each 2" I am using the body/item from the excel in the previous step. In "Language Array" I am splitting the output from the previous step and using its output in the append to array section. In apply to each 2 I am creating the item and within the correct column i used a dynamic value of my variable as the array value for the column. Finally I am setting the variable to null so it can repeat the loop without using the same data in the array.
Any and all help would be greatly appreciated!
Thank you,
Jackson
Hi @ManishSolanki! This worked for my flow thank you so much!
Here is the sample flow to save multi choice column in SharePoint list.
Input excel file:
Target SharePoint custom list (name LangList):
Flow:
After fetching rows from excel, add "Apply to each loop" to iterate the rows. Inside apply to each block, add "Select" action to create an array of values for multi select choice column. We would use expression in "From" parameter to split the value of excel column (Language) as shown below:
Below expression needs to be added in the expression box as highlighted in the above screenshot:
split(item()?['Language'],',')
Pls use actual column name from the excel in the above expression.
Expression used for key/value in Map parameter:
Finally, add create item action to add item in SharePoint list.
Click "Switch to input entire array" button on the right side of multi choice column:
Next, pass the output of select action in the multi choice column:
Output:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional