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 Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,404)