Multiple Flows updating One Master Data Excel workbook

(0) Share

Report

Posted on by GarethLynch

Hi all,

I am new to Power Automate and Flows.

I have created a scheduled flow which Succeeded, the flow is to list all rows within the master data table within the first workbook and the same for the 2nd, it then applies an "Equal to" query to identify the same rows in both data tables. If matched I've asked for it to update the multiple rows/ Cells from the 2nd table so that the master table is updated.

My question is that I need to create 57 versions of this as we have 57 workbooks that need to update the master file.

Just one flow took 4 Hours, if I run all 57 flows in parallel (At the same time of day) does it have to wait for each flow to finish? or would it run at the same time?

Each table has a unique ID that matches the master table so there will be no conflicting Unique ID's within the 57 data tables.

Any advice would be appreciated.

All responses (5)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Multiple Flows updating One Master Data Excel workbook

@GarethLynch

if this solve your problem. please mark this as solution to help others.
GarethLynch 5 on at

Like (0)

Report

Re: Multiple Flows updating One Master Data Excel workbook

Thank you very much
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

Re: Multiple Flows updating One Master Data Excel workbook

@GarethLynch

Your design is a sequential flow. As per your requirement you can create parallel flow. While clicking on + sign select add parallel branch and add a compose (temporarily) and drag these action under parallel branch. once you dragged it delete compose action.

Thanks
Hardesh
GarethLynch 5 on at

Like (0)

Report

Re: Multiple Flows updating One Master Data Excel workbook

Thank you for getting back so quickly @Hardesh15

My flow is set out as below, I would create 57 of these and they could all run at the same time?
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Multiple Flows updating One Master Data Excel workbook

@GarethLynch

All Parallel branch run on same time. You can update master sheet with parallel flow.
Thanks
Hardesh