Skip to main content

Notifications

Community site session details

Community site session details

Session Id : hH3MWlfXGaIARunulJjneE
Power Automate - Building Flows
Answered

Help needed with importing data from excel into sharepoint list!

Like (0) ShareShare
ReportReport
Posted on 31 Jan 2024 18:38:23 by 7

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: 

jacksonvanslyke_0-1706725876927.png

jacksonvanslyke_1-1706725917678.png

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

 

 

 

  • jacksonvanslyke Profile Picture
    7 on 02 Feb 2024 at 16:39:39
    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 Profile Picture
    15,085 Super User 2025 Season 1 on 02 Feb 2024 at 09:17:25
    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:

    ManishSolanki_0-1706864494607.png

     

    Target SharePoint custom list (name LangList):

    ManishSolanki_1-1706864552425.png

     

    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:

    ManishSolanki_2-1706864751202.png

    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:

    ManishSolanki_3-1706864972210.png

    Next, pass the output of select action in the multi choice column:

    ManishSolanki_4-1706865105983.png

     

    Output:

    ManishSolanki_5-1706865358708.png

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started