Answered

Append data from saved excel into other pre-existing excel file

Like (0) Share

Report

Posted on 20 Jan 2021 22:48:02 by alisonmeininger

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

All responses (6)

Answers (1)

manuelwilhelm 2 on 06 Mar 2024 at 08:04:20

Like (0)

Report

Re: Append data from saved excel into other pre-existing excel file

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
AJM001 6 on 02 Jun 2023 at 19:55:47

Like (1)

Report

Re: Append data from saved excel into other pre-existing excel file

Hi Serbay,

Did you find a better way to append to an excel file?
Community Power Pla... on 15 Jun 2022 at 05:00:15

Like (1)

Report

Re: Append data from saved excel into other pre-existing excel file

Hi,

What if the exported file has no table format. it is simply an excel sheet that needs to be appended?
alisonmeininger 29 on 26 Jan 2021 at 15:34:17

Like (0)

Report

Re: Append data from saved excel into other pre-existing excel file

Thank you so much for the very detailed response! I will try out this solution and let you know if it works. Thanks again!
Serbay 213 on 23 Jan 2021 at 13:22:41

Like (0)

Report

Re: Append data from saved excel into other pre-existing excel file

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.
Verified answer

v-yiwenxie-msft Microsoft Employee on 21 Jan 2021 at 07:00:59

Like (1)

Report

Re: Append data from saved excel into other pre-existing excel file

Hi @alisonmeininger

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.