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:
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,
Holy Crap, it works. Thank you, Thank you, Thank you!!!!
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
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.
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