cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User II
Super User II

@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

View solution in original post

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,243)