Patch SP List from Excel file with multiple choice columns

[LennartWalldén]

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?

[v-bofeng-msft]

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]

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 · Accepted solution]

Found a solution here: 

Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

Thanks to @RezaDorrani