cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LennartWalldén
Advocate II
Advocate II

Patch SP List from Excel file with multiple choice columns

Hi all,

 

I am trying to import 500 records from an Excel file that should be stored in a Sharepoint list. Some of the Excel columns has multiple comma separated values, and these should be stored in multiple choice fields in Sharepoint.

Column A
A, B, C
B,C
A,B

 

My problem is that I can't figure out how to convert these multiple values into tables on the fly during the conversion. 

 

Could someone provide me an example of how to do this?


1 ACCEPTED SOLUTION

Accepted Solutions
LennartWalldén
Advocate II
Advocate II
3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @LennartWalldén ,

 

I've made a test for your reference:
1\My Excel file

vbofengmsft_0-1667525474699.png

2\My flow

vbofengmsft_1-1667525532078.png

  1)

  split(items('Apply_to_each')?['Column A'],',')

  2)

  item()

3\Result

vbofengmsft_2-1667525580351.png

 

Best Regards,

Bof

 

 

LennartWalldén
Advocate II
Advocate II

Hi @v-bofeng-msft 

 

Thanks for your reply. Brilliant solution! 🙂 However, the SP list already has objects that should be updated with Column A data. So in your case Title 1,2 and 3 does already exist in the list and the Column A does also exist already.

What would the flow look like then?

Best regards
Lennart

LennartWalldén
Advocate II
Advocate II

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,971)