Hi everyone - I'm very new to Power Automate so hopefully this isn't a silly question. I have a set of 4 emails that get sent to my inbox every day, each with an Excel file attachment. I have currently implemented a flow that saves each of these Excel files to my OneDrive folder. From this point, I'd like to take the data in each of the 4 Excel files and append that data into the 4 corresponding sheets of another, pre-existing Excel file (columns are the same between the emailed Excel and pre-existing Excel). Is this possible? (Currently I do this as a completely manual process, i.e. I open one Excel file from my email, then copy/paste the rows from that file into one of the four tabs that corresponds to the data in my pre-existing Excel file).
Thanks!
Alison
Hi,
I tried setting up this Flow, but cant complete it.
The input columns for the respective columns in the master file are not given as dynamic content to me (probably since at the time I set up the script, the New excel Sheet with the new data does not exist yet).
Do you have any idea on what I'm doing wrong?
Kind Regards
Manuel
Hi Serbay,
Did you find a better way to append to an excel file?
Hi,
What if the exported file has no table format. it is simply an excel sheet that needs to be appended?
Thank you so much for the very detailed response! I will try out this solution and let you know if it works. Thanks again!
Hi,
Is there any other way to merge data or add data from one workbook to another? Because in the case of huge amount of data, this method takes hours to be completed.
You need 2 flows to meet your need.
The first flow is ,as you implemented, to save each of the emailed Excel files to your OneDrive folder.
The second flow is to append emailed Excel data into the 4 corresponding sheets of another pre-existing Excel file.
And to match the emailed Excel data with the columns in another pre-existing Excel file, there is an easier way to check whether they are matched---just ensure the table names are the same.
You can edit table name by selecting the table, choosing ‘Table Design’ and then editing the table name:
I’ve create the second flow as below:
First, if a file is created in a specific folder in OneDrive, get file metadata and check if the file is an excel file.
If yes, get tables in the excel file and add an ‘apply to each’ action.
If no, do nothing.
For the ‘apply to each’ action:
Add a ‘switch’ action:
The switch action is used to find matched case. And if there is a matched case, then append the emailed excel data into pre-existing excel file.
There are four cases and an default one.
For each case in ‘switch’ action:
Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional