Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iBFG/JsjCYzZFs1aIRZNmf
Power Automate - Building Flows
Answered

Turn multiple choices in Microsoft Forms into multiple rows in Excel

Like (0) ShareShare
ReportReport
Posted on 1 Dec 2023 21:24:47 by

content removed

  • cjatseaspan Profile Picture
    4 on 02 Jul 2024 at 14:26:10
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Hi @SunnyRKFOODLAND. No, there are no sections. I have 87 continuous questions and based on a selection it branches to a certain point and I have end of form at multiple questions in between.

  • SunnyRKFOODLAND Profile Picture
    101 on 01 Jul 2024 at 06:30:38
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Below is the Test Form 

    SunnyRKFOODLAND_0-1719815083852.png

    I am adding data To Excel table

    SunnyRKFOODLAND_1-1719815131711.png

    and now the FLow

    SunnyRKFOODLAND_2-1719815194179.png

    Add all Trailer Numbers in Compose Action 

    in next action use filter array  and use below formula 

    From

    split(outputs('Compose'),',')
    trim(item()) not equal to (blank)
    and then use initialize variable and use the output of filter array in value
     
    SunnyRKFOODLAND_3-1719815354655.png

     

    Hope This Helps your problem 

    If I helped you please accept it as a solution and hit like.

    Thanks

  • SunnyRKFOODLAND Profile Picture
    101 on 01 Jul 2024 at 05:06:49
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Does your Microsoft Form have a section for Each Selection & each Section must have 1,1 2, 123 till 6th option for entering.

    Am I Right?

  • cjatseaspan Profile Picture
    4 on 28 Jun 2024 at 17:43:21
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Hi @wskinnermctc,

    I have a similar question but its not exactly multiple choice. I have a question that has 5 options.

    cjatseaspan_0-1719596139849.png

    When I select 1 it asks details for 1 trailer

    cjatseaspan_1-1719596316445.png

    When I select 2 it asks me information of 2 trailers, then

    cjatseaspan_2-1719596374968.png

    and so on.
    Right now on one submit every trailer information gets saved in one record. There's also branching involved so there can be another reservation for more trailers.

    What I need is that if there were 2 trailers selected, then the information captured in those 2 text boxes should be captured in 2 different rows and not one. Is that possible through Power Automate?

     

    Let me know in case you have further questions

     

    Regards

    CJ 






  • SunnyRKFOODLAND Profile Picture
    101 on 28 Jun 2024 at 04:47:12
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    action before the Json you need run then to flow and then copy the output and then in then add parse json action and then click generate json from example and paste copied output in that and done. you will get json

  • Nicole2 Profile Picture
    2 on 30 May 2024 at 21:59:26
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    I want to ask about how to form the JSON part! Thanks

  • SunnyRKFOODLAND Profile Picture
    101 on 05 Feb 2024 at 11:39:52
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    How can I achieve this in Sharelist

  • CU16121921-0 Profile Picture
    on 22 Jan 2024 at 22:47:37
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

     

     

     

  • wskinnermctc Profile Picture
    6,517 Super User 2025 Season 1 on 14 Dec 2023 at 14:41:15
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Hi @qphalen , if I'm understanding your question correctly, the process would be relatively the same except you would need an additional array in the beginning for the names, then apply to each the names array similar steps from the example.

     

    However, I don't understand how the multiple names are going to be identified? They are selecting the multiple names from the form (why would names be available for selection)? Or will they enter the multiple names via text? 

     

    I think if they are entering the names via text then you will have an issue with errors trying to splice out individual names. Then you will start running into problems dealing with actions on single names vs multiple names.

     

    I think they should just submit a single form per-person. It is not an unreasonable request functionally. A form should take no more than 30 seconds or a minute to complete, so that is like 2 minutes for 2 employees at most.

     

    Meanwhile you will spend hours trying to construct a flow that can be flexible and prevent errors, just so they can input multiple people at once. The cost benefit will be to have a single form submission per person. 

     

    If you need more assistance, you should submit a new post to the forum. Solvers/SuperUsers don't really look at older posts that were solved, so you would get an answer with a new post that is unsolved.

  • CU-19081224-4 Profile Picture
    39 on 13 Dec 2023 at 18:30:30
    Re: Turn multiple choices in Microsoft Forms into multiple rows in Excel

    Hi @wskinnermctc - thanks for this solution as you have also helped me solve my problem! But I am wondering if it is possible to extend this further. I have a form where I would like to be able to select multiple names and multiples of another question which is Products as this is for a training request.

    Essentially a manager would submit multiple names to be trained on multiple products and I would like these to come through as individual lines.  

    In OPs post - what if there were 2+ names to choose (Tom Hanks and Stevie Wonder) and they were all to be joining BCY, ATL and NCC. That way I wouldn't have to submit a new form for each individual person. 

    Can I use the same process to isolate the names as well as the LERT's? That way each has their own row in excel. 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard