Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Break out Multi-Answer...
Power Automate - Building Flows
Answered

Break out Multi-Answer response into separate cells

(0) ShareShare
ReportReport
Posted on by jmwinters 11

I am familiar already with forms and dumping into excel with values. But i have a question with multi-answer questions. 

 

I need to separate out the answers from a couple of multi-answer questions in a MS Form into individual cells. I would like to just put a X or some check in the cells for each multi-answer response if possible. See below for example layout:

 

Form: 

Question 1 - Checkbox

Question 2 - multi answer

    A

    B

    C

Question 3  - Text Box

Question 4 - Multi answer

    T

    Y

    Z

 

Excel Sheet: 

Question 1  |  Question 2 - A  |  Question 2 - B  | Question 2 - C  |  Question 3  |  Question 4 - T | Question 4 - Y  |  Question 4 - Z  |

example 1   |             X            |              X           |                           |   example 3  |             X           |                          |             X            |

 

  • Hanhdo Profile Picture
    Hanhdo 3 on at
    allo, Re: Break out Multi-Answer response into separate cells

    Hallo @RobElliott, I am following your instruction to Break out Multi-Answer response from MS-form into Power BI. But I am stuck at step "add the Planner Create a task action" since it only applies for SharePoint questionnair and seems like MS form doesnt.

    Could you please help to specify how it works for the case of Ms-form from this step onwards? 

    Thank you so much for your helpp!!

    Hanh

  • RobElliott Profile Picture
    RobElliott 10,157 Super User 2025 Season 1 on at
    Re: Break out Multi-Answer response into separate cells

    @jmwinters, yes you can copy them. Clcik the 3 dots in the top right of the action and select the first menu item Copy to clipboard. Then when you add an action in the next case select My clipboard as the source and pick the action that you saved.

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • jmwinters Profile Picture
    jmwinters 11 on at
    Re: Break out Multi-Answer response into separate cells

    This worked beautifully for my scenario. It of course gets pretty clunky when you start adding as many case statements as I had.

     

    Of note: Unfortunately Microsoft doesn't seem to allow you to Copy actions within case statements to make your life easier setting them up.

  • v-alzhan-msft Profile Picture
    v-alzhan-msft on at
    Re: Break out Multi-Answer response into separate cells

    Hi @jmwinters ,

     

    Please take a try with @RobElliott 's solution and and feel free to reply here if you have any problems.

     

    Best regards,

    Alice       

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    RobElliott Profile Picture
    RobElliott 10,157 Super User 2025 Season 1 on at
    Re: Break out Multi-Answer response into separate cells

    @jmwinters because the Forms question can have multiple answers it brings it into the flow as an array. To use each response in a following action you need to split it into a string and have a switch on that string. I answered a similar question to yours on Saturday. Have a look and see if it helps:
    https://powerusers.microsoft.com/t5/Building-Flows/Case-Switch-from-an-MS-form-not-working/m-p/442725#M52294 

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans