web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : P1b0s9fiCj3mNNVZ4OuNzJ
Power Automate - Building Flows
Unanswered

Can one form upload to multiple sheets the exact same data automatically?

Like (1) ShareShare
ReportReport
Posted on 18 Apr 2024 22:02:53 by 6

If I have one single Microsoft form, is it possible to get all the results duplicated into multiple sheets automatically. I want it where each time results are entered it updates all the sheets simultaneously.

  • trice602 Profile Picture
    14,058 Super User 2025 Season 2 on 20 Apr 2024 at 14:38:45
    Re: Can one form upload to multiple sheets the exact same data automatically?

    Hi @Unknown3 ,

     

    Let's figure this out together, can you please share your flow here?

     

     

  • Andrew_J Profile Picture
    1,962 Moderator on 19 Apr 2024 at 21:10:08
    Re: Can one form upload to multiple sheets the exact same data automatically?

    @Unknown3 

     

    @trice602possible solution was for multiple FILES not sheets as you mention above.  You need to set up the new files you want to create and refrence them in the flow for the flow to work.

     

    Also where has this mater excel file come from there has been no mention of this in the thread.

     

    Andrew

  • Unknown3 Profile Picture
    6 on 19 Apr 2024 at 21:02:59
    Re: Can one form upload to multiple sheets the exact same data automatically?

    Hi! So I made this flow and entered all my parameters but it isn't working. My form only updates the original excel sheet and not the other sheets. Is there something I could be doing wrong? 

     

  • AlexEncodian Profile Picture
    4,409 Moderator on 19 Apr 2024 at 13:48:37
    Re: Can one form upload to multiple sheets the exact same data automatically?

    @Unknown3 

    You can also put the actions in series (rather than parallel branches) within a "Scope" Add row to tables.

     

    Depends on your personal preference and potential execution speeds.

  • trice602 Profile Picture
    14,058 Super User 2025 Season 2 on 19 Apr 2024 at 00:21:07
    Re: Can one form upload to multiple sheets the exact same data automatically?

    Hi @Unknown3 ,

     

    Yeah, so your flow may look something like this, in this example adding a row to 4 sheets at the same time.

     

    trice602_0-1713486022498.png

     

     

  • Andrew_J Profile Picture
    1,962 Moderator on 18 Apr 2024 at 22:32:10
    Re: Can one form upload to multiple sheets the exact same data automatically?

    @Unknown3 

     

    You should be able to do what you want to do, I suggest you use a Paralle Branch for each duplicate form you want to populate.  You will only be alowed 50 branches.

     

    Andrew

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2