You’re offline. This is a read only version of the page.
Hi
I am a newbie. I need to split a string from a multi select dropdown (Microsoft form) into single records in a Sharepoint list. Please see the attached image.
Thanking you in advance for your assistance.
Christopher
Select the appropriate dynamic content from the Get user profile (V2) action and insert it into the Create Item action.
Hope this helps!
Hi
Before I get to the string split I need to get the users information. The department, birthday and display name for use in the Create item action. I'm not sure how to do that. Please see my progress so far in the attached image.
Thanks
Hey @cseewaldPAD1972 ! I'm happy to help you with that.
In the "Apply to each" section, i'm using this formula:
Share
Report
All responses (
Answers (split(outputs('Get_response_details')?['body/123xyz'], ',')This formula splits the responses from the multiple-choice question into separate items, using commas as separators, creating a list of user selected options.
Then, in the "Sports" column, of the create Item in Sharepoint list i'm using this formula:
split(items('Apply_to_each'), '"')[1]This formula removes any extra quotation marks or commas that might have been included in the responses.
Does that sound about right? If so, I'm glad I could clarify the steps involved! Feel free to ask if you have any more questions.
Start with a manually triggered flow. Depending on how many items you have in your SP List, I would recommend limiting the Top Count to a smaller number than the total number of items in your list. This will increase the speed of your flow runs. Instead of returning all items in your list—it'll limit the Get Items action to the number entered into the Top Count field.
Insert an Apply to Each action to loop through each item returned from the Get Items action.
This next action is optional. However, since you are new it'll help you better understand what's going on in your flow.
Add a Compose action to store the Multi-Choice dynamic content. My multi-choice column is named Multi-Choice select the appropriate dynamic content in your flow.
Run a test. Review the output of the Compose action. This will show you the output of the data from the multi-choice column. It's an array.
Add Another apply inside the existing apply to each action. I should mention that it's important to rename your actions to keep things organized!
In the new Apply to Each action insert the Multi-Choice dynamic content (same one you inserted into the Compose action.
Add another Compose action. Again, this is optional. However it'l help you to better understand what is going on in your flow. Insert the Value dynamic content of your multi-choice column. In my case it's Multi-Choice Value.
Run a Test. Confirm the Compose action is displaying each multi-choice value for the current item being looped through.
Add a Create an item action inside the nested Apply to Each action.
Each time the nested apply to each action loops through a multi-choice selection, it'll create a new item in your SP list.
For the single choice value column, select Enter Custom Value. Insert the out from the Compose action above.
Run a test.
Turn on the Concurrency Control for the nested apply to each action. By default the Concurrency control is turned off which means that the Apply to Each action loops through each item one after the other.
When the concurrency control is turned on, the Apply to Each action loops through a number of items at the same time. It’s important to note that if you are using a set variable action—you should leave the concurrency control off.
Toggle it on and increase the Degree of Parallelism.
Run another test. See how quickly your flow runs now.
Don't forget to remove the Top Count from the Get Items action.
If you'd like to level up your Power Automate skills check out this video: Power Automate Beginner Tips and Tricks | 5 Things You Need to Know – Part 1
I cover the following in this video tutorial:
✅ Power Automate Beginner Tips and Tricks
✅ Why use the Manual Trigger instead of an Automated Trigger
✅ 3 Ways a Compose Action can help you build better flows
✅ How to Manually Trigger a flow with a specific Date and Time
✅ How to return a count of items
✅ How to use the top count
✅ How to send test emails
Hope this helps!
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
