Help needed with importing data from excel into sharepoint list!

Like (0) Share

Report

Posted on 31 Jan 2024 18:38:23 by jacksonvanslyke

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

Categories:

Business Process Flows

All responses (2)

Answers (1)

jacksonvanslyke 7 on 02 Feb 2024 at 16:39:39

Like (0)

Report

Re: Help needed with importing data from excel into sharepoint list!

Hi @ManishSolanki! This worked for my flow thank you so much!
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 02 Feb 2024 at 09:17:25

Like (0)

Report
Re: Help needed with importing data from excel into sharepoint list!

Hi @jacksonvanslyke

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:

Value

trim(item())

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.