cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhorn30
Advocate I
Advocate I

Creating separate SharePoint list items for multi-select on Forms

I have a Microsoft Form that has a multi-select item. I want to write the Form response to a SharePoint list, but I want to write a new entry for every multi-select item chosen by the user. 

 

I've used this forum post as the basis for my Flow: https://powerusers.microsoft.com/t5/Building-Flows/Split-multi-answer-Forms-question/td-p/154425

 

However, it seems a few things has changed with Flow since this post was made as e.g. "List of response..." is not an option anymore with the first "Apply to each"

 

flow apply for each.png

 

I'm therefore not sure what to put in the first "Apply to each" as none of the three options I have (Response Id; resourceData; body) are of type Array.

 

Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions

@mhorn30 

 

Your flow is not designed well.

33.jpg

 

I created a multi select question and i have 3 choices.

 

Compose 2 current item will give you all choices.

 

Thanks

Hardesh

View solution in original post

4 REPLIES 4
Hardesh15
Super User
Super User

@mhorn30 

 

Use Response Id from dynamic content.

 

Thanks

Hardesh

Flow is not happy with "Response ID"

 

mhorn30_0-1598365306318.png

@Hardesh15 

@mhorn30 

 

Your flow is not designed well.

33.jpg

 

I created a multi select question and i have 3 choices.

 

Compose 2 current item will give you all choices.

 

Thanks

Hardesh

Thank you! That helped me solve the main problem.

 

I made some additional changes to the code to make it work for my multi-select:

 

mhorn30_0-1598374811017.png

 

Compose Replace:

replace(replace(replace(outputs('Get_response_details')?['body/ra33eac1de34949dd9f6544d35843cbf5'],'["',''),'"]',''),'","',',')

 
Compose Split:
split(outputs('Compose_Replace'),',')

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,121)