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"
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?
Solved! Go to Solution.
Your flow is not designed well.
I created a multi select question and i have 3 choices.
Compose 2 current item will give you all choices.
Thanks
Hardesh
Your flow is not designed well.
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:
Compose Replace:
replace(replace(replace(outputs('Get_response_details')?['body/ra33eac1de34949dd9f6544d35843cbf5'],'["',''),'"]',''),'","',',')
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |