You’re offline. This is a read only version of the page.
Announcements
3
Anyone able to help with this? I have a form which has an option for responders to select more than one choice on a question. For each choice they select, a different approver will be required. Can power automate separate each choice into sperate rows when exporting to excel? I've see tutorials for splitting into columns but that's not what I want. What I want is for each choice to be listed on separate rows.
@tomiadedeji Pls see this post How to store Microsoft forms responses in a SharePoint list? – Gopenly
Focus on this line-
To store form multiple choices in your SharePoint choice column, you will create an array for computer accessories choices.
Split(replace(replace(replace(outputs(‘Get_response_details’)?’body/rc9bce6a0275e4d789bd1098d569868d5′],'[‘,”),’]’,”),'”‘,”),’,’)Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
Share
Report
All responses (
Answers (
