You’re offline. This is a read only version of the page.
147
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?
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
Found a solution here:
Thanks to @RezaDorrani
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
Hi @LennartWalldén ,
I've made a test for your reference:
1\My Excel file
2\My flow
1)
2)
3\Result
Best Regards,
Bof
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
