Trying to build a flow with MS forms multi-select

(0) Share

Report

Posted on by Carlington

Hello All,

I have been messing around with power automate for a bit and have been able to create some simple flows.

I have one that's a real headscratcher for me.

I am using MS forms, power automate, emails and MS excel

I wanna create a flow like this:

Someone uses ms form to create responses. one of the responses is a multi-select field (lets say the field is labeled "select all you prefer and the selections are "pie", "cake", "chicken", "hot dogs")
the multi-select field response is then taken and converted into an email where all selections are listed on separate lines in the email body. like if they selected pie and cake it would show as
while this is happening, an excel sheet is being automatically updated with the responses in separate columns.

I know it has something to do with converting the responses into an array but i cant figure that part out.

Something similar to this flow below (this flow is based on a single response field).

So the form is filled out and saved,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Carlington ,
I have tried many solutions, but I still can't autofill the options into separate excel table columns.
Could you accept all food as one column? Something like this.
If you can accept it, I did a test for your reference.
Please insert a table into your worksheet.
In my scenario:

replace(replace(replace(body('Get_response_details')?['r1165cedd4c3a4b8d8a0cffa4adfb5496'],']',''),'[',''),'"','')

My MS Form:
My Outlook Inbox:
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Carlington 23 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much sunshine for your work and the time you invested in helping. I am ok with the excel being one column however I specifically need the email info to be new lines instead of separated by commas i.e a vertical list.

When I try your method the email looks like this

I am specifically looking for this:
I saw somewhere its said you can use a new line using compose and join the result and the new line but cant figure it out.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Carlington ,
Please add the compose operation before the 'Send an email' control.
replace(outputs('Remove_characters'),',','<br>')
My Outlook Inbox:

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Carlington 23 on at

Like (0)

Report
Copy link

Link copied!

Holy Crap, it works. Thank you, Thank you, Thank you!!!!

Was this reply helpful? Yes No