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

Like (1) Share

Report

Posted on 18 Apr 2024 22:02:53 by Unknown3

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.

All responses (6)

Answers (0)

trice602 14,058 Super User 2025 Season 2 on 20 Apr 2024 at 14:38:45

Like (0)

Report

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 1,962 Moderator on 19 Apr 2024 at 21:10:08

Like (0)

Report

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 6 on 19 Apr 2024 at 21:02:59

Like (1)

Report

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 4,409 Moderator on 19 Apr 2024 at 13:48:37

Like (1)

Report

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 14,058 Super User 2025 Season 2 on 19 Apr 2024 at 00:21:07

Like (0)

Report

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.
Andrew_J 1,962 Moderator on 18 Apr 2024 at 22:32:10

Like (0)

Report

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