Skip to main content

Notifications

Power Automate - General Discussion
Answered

Trying to build a flow with MS forms multi-select

(0) ShareShare
ReportReport
Posted on by 23

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:

  1. 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")
  2. 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 Carlington_1-1698874267954.png

     

  3. while this is happening, an excel sheet is being automatically updated with the responses in separate columns. Carlington_2-1698874607888.png

     

 

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).

Carlington_0-1698873791001.png

So the form is filled out and saved, 

  • Carlington Profile Picture
    Carlington 23 on at
    Re: Trying to build a flow with MS forms multi-select

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

  • Verified answer
    Re: Trying to build a flow with MS forms multi-select

    Hi @Carlington ,

    Please add the compose operation before the 'Send an email' control.

    vyetonggumsft_0-1699108428473.png

    replace(outputs('Remove_characters'),',','<br>')

    My Outlook Inbox:

    vyetonggumsft_1-1699108498177.png

     

    Best  Regards,

    Sunshine Gu

  • Carlington Profile Picture
    Carlington 23 on at
    Re: Trying to build a flow with MS forms multi-select

    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

    Carlington_0-1699029571040.png

     

    I am specifically looking for this:

    Carlington_1-1699029597361.png

    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.

  • Re: Trying to build a flow with MS forms multi-select

    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.

    vyetonggumsft_0-1698908750514.png

    If you can accept it, I did a test for your reference.

    Please insert a table into your worksheet.

    In my scenario:

    vyetonggumsft_1-1698909278497.png

    vyetonggumsft_2-1698909316029.png

     

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

     

    vyetonggumsft_3-1698909446973.png

    My MS Form:

    vyetonggumsft_4-1698909698680.png

    My Outlook Inbox:

    vyetonggumsft_0-1698909946784.png

    Best Regards,

    Sunshine Gu

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard