Patch SP List from Excel file with multiple choice columns

(0) Share

Report

Posted on by LennartWalldén

181

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?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @LennartWalldén ,

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

2\My flow

1)

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

2)

item()

3\Result

Best Regards,

Bof
LennartWalldén 181 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

LennartWalldén 181 on at

Like
a
(0)

Report
Copy link

Link copied!

Found a solution here:
Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

Thanks to @RezaDorrani
Orbin 2 on at

Like
a
(0)

Report
Copy link

Link copied!

If your divider in the Excel is ";#" instead of "," (which you could do by search and replace) then sharepoint can identify them as individual choices.

So import Excel > set column type "Choice"
Go to the imported Sharepointlist > go to column > column settings > Edit > more options > checkbox allow multiple choices > now create each individual choice "A" "B" "C"

After saving it will automatically add the multiple choices for the whole list
I hope this description is clear enough

Best Regards
Robin