Unanswered

Update multiple Excel files from a master Excel sheet

(0) Share

Report

Posted on by Woodhouse

Hello All,

I am new to Power Automate and attempting to conceptualize a workflow which automates a batch update for multiple excel files. Essentially, I have a single "master" excel file (stored within a sharepoint folder) and need to automatically update multiple excel files (in an alternative sharepoint folder) files when the master file is updated or configured. Each of the sub-files which I need updated also contain the same table sheet within them. Is there anyway to do this with power automate? Any information or insight would be greatly appreciated!

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Do you want to do this in the Power Automate service or with PAD (Power Automate Desktop) ?

Was this reply helpful? Yes No
Woodhouse 6 on at

Like (0)

Report

I'm working within the Power Automate Service

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

This would be your trigger

and here are the actions you can perform (plus a couple more)

You will now need to decide if you want to copy the entire master file, or if you want to harvest the data changes and apply them to the dependent files too.

Was this reply helpful? Yes No
Woodhouse 6 on at

Like (0)

Report

I went ahead and made some preliminary flows which did what I wanted them to do, however, it seems I've ran into a roadblock trying to get a data validation that table 2 is equal to table 1 which ends the do until/apply to each loop I have setup. Below are some pictures of this particular flow, it is manually triggered now as that works better with what I needed (batch update wise). Flow overview

Apply to each/Do Until Loop
As of right now, the loop is set to perform the updates until the value of table two equals table one, but it runs infinitely and never validates this for some reason. Ideally, I want it to first apply any updates and then check that the values are equal so the apply to each/do until loop can be ended. Any help would be greatly appreciated on how to accomplish this!

Was this reply helpful? Yes No