Skip to main content
Community site session details

Community site session details

Session Id : kowZ1FZrMAReH5yqWjTK3v
Power Automate - Building Flows
Unanswered

Form sections fill separate rows in excel form via flow

Like (0) ShareShare
ReportReport
Posted on 13 Feb 2023 14:59:52 by 4

I have a form for work uniform choices.  It has sections for 10 items.  If they chose to say they don't require any more items they can submit the form, if they chose they do need more items then the next section becomes available. 

I have a flow for the first section to auto populate an excel form. How would I have it to that each section fills a line on the excel table?  And how would this work on a per submission basis? 

I have been searching the net and so far have not found anything. 

 

I did debate just having them submit the form each time for each item, but they are already grumpy as it is at having to use technology. 

  • Sbrady236 Profile Picture
    4 on 20 Feb 2023 at 12:29:07
    Re: Form sections fill separate rows in excel form via flow

    Ah ok.  I have my form in sections.  First section is Item 1, second is item 2 and so on. So when they answer section one its Item 1:type.  When they answer section 2, it's Item 2:type. 

     

    Would I just have it as the switch is that they pick from that field, then a switch for items 1-10? 

  • RobElliott Profile Picture
    10,166 Super User 2025 Season 2 on 13 Feb 2023 at 17:49:09
    Re: Form sections fill separate rows in excel form via flow

    No you've got that wrong. The switch doesn't need to have anything to do with if they want to order more, that is handled by the branching in the form. You just need the switch to look at whether they want to order a shirt or trousers etc, with 1 switch for each type of item they want to order and a create item action to add the item they want to order to the list.

  • Sbrady236 Profile Picture
    4 on 13 Feb 2023 at 17:42:47
    Re: Form sections fill separate rows in excel form via flow

    Thanks.  It seems to accept it ad says the flow is working, but it doesn't return the second row to the excel sheet. I put eh switch in for when they select if they need to order more.  They say yes, then I put to get response details and again add row to excel sheet. I have tried it without the get response and it doesn't take the second lot o selections either way. 

     

     

     

  • RobElliott Profile Picture
    10,166 Super User 2025 Season 2 on 13 Feb 2023 at 15:56:46
    Re: Form sections fill separate rows in excel form via flow

    @Sbrady236 the way I would do this (other solutions are available) is to use a series of Switch controls based on each question. In the image below it creates a new SharePoint list item, but the principle is the same for Excel. You'd then click New Step to add the next switch control and so on.

     

    1-Flow.png

     

    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

Quick Links

Announcing our 2025 Season 2 Super Users!

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

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!

Loading complete