Unanswered

Copying Data from a recently created Excel File to a Master Excel File

(0) Share

Report

Posted on by dh79

Every morning, a new Excel File is created, and saved in my OneDrive Folder. This Excel File contains five tables with alarm information, all the information from each table, is manually copied over into a Master File, which has the same table names but holds all the historic data, to be able to identify trends.

I would like to create some form a flow, whereby I can copy the data from this newly created file every morning, and paste this data into the Master File.

I've been looking at various ideas already suggested, such as using the "When File is created template" and then using "List Rows Present in a Table", however hit a brick wall trying to get the data added to the Master File.

Is anyone able to potentially assist?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

jinivthakkar 4,187 on at

Like (1)

Report

@dh79 before you start you need to check if the master data excel and the data excel that you receive have a table structure, if yes than you can try. If the data is not in a table then its not possible, if the data is in table then you can try I am not sure but there would still be a chance. Table to be read/write should be in table in all sheets.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
dh79 9 on at

Like (0)

Report

@jinivthakkar Thanks for your time.
Yes both the master and daily excel files, have exactly the same table structure.

Was this reply helpful? Yes No
neerajsu 68 on at

Like (0)

Report

This seems like a trivial problem. Have you tried using "Add a row to an excel table" action? Here's a youtube video explaining how to do it. https://www.youtube.com/watch?v=kbYGFIo0WGc

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (0)

Report

@dh79 this is how your flow would look like, schedule it to run daily and then build it like this.

This block would read 1 table and add rows to your master table, you will have such blocks for each table. For e.g. if you have 4 tables to read and add rows in master table you will have such 4 blocks.
Hope this helps
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
dh79 9 on at

Like (1)

Report

@jinivthakkar Thanks very much for this it’s certainly done the trick.

Was this reply helpful? Yes No