Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Flow for Merge Excel files

I created Microsoft Form for collection of Excel files in a specific template from my team members on daily basis. I need to combine all received files in a particular day in a single master Excel file (contains progress of past days) which will be forwarded to my manager.


Table format for template and master file is below.


DateTeam Member NameProgress
6/7/2020Mr. ABC20%


I tried to create flow but couldn't find any action which dynamically reads new received file and copies data to master file. If anyone of you knows any solution or other workaround do let me know please.

Responsive Resident
Responsive Resident



Hello @Worker66 ,


You can perform following steps to merge your daily excel files.


1) create one file in one drive that is your master file 

2) create action to read attachments from email . (You can apply filter conditions for reading specific emails)


3) update one drive file with content you read from previous step.


Hello @anupam8555 ,


Do you have screen shots of how to do step 1-3.




Responsive Resident
Responsive Resident

Hi @mlam ,


Here is what it looks like. You might have tweak that into your needs but basically its upload file to oneDrive , read that file from oneDrive and update content to master file in oneDrive.






(Please mark it as resolved or give thumbs up if it helps you)

If you have large Excel files this could be problematic.  Powershell definitely does this quicker. 

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,158)