Unanswered

How to merge several Excel table from the same file into one using Flow?

(0) Share

Report

Posted on by geo97

Hi everyone, I need your help building a Power Automate Flow.

I'm pretty new to this tool and I can't do anything with it without following youtube videos.

Here's my situation:

I have an Excel file with 17 sheets named P01, P02, ... to P17.

Each sheet has a table with headers. The headers between the tables are all identical.

The name of the table is 'Chapter1_Table' for sheet P01, 'Chapter2_Table' for P02, ... to 'Chapter17_Table' for P17.

I created an additional sheet named 'All' with a table in this sheet named 'All_Table'.

This table also has the same headers as the others. I want to create a Power automate flow that does the following:

1. Check the 'All_Table and delete its content before doing anything.
2. Copy the data from the tables in the other sheets, from P01 to P17
3. Paste this data in the 'All_Table' located in the 'All' sheet without overwriting any data.

Any idea on how I can do that? 😕

Thank you very much

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello,

can you tell me how many rows you have in the all Rows?

You have 2 options
1. Do a List Rows in a table and loop and delete 1 at at ime
2. Use a script and call the script in the file

Depending on the number of rows, both can stink..

I can help you with the rest, but curious if its a good thing to do at all.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
geo97 14 on at

Like (0)

Report
Copy link

Link copied!

Hey, thank you for your message. The number of rows per table varies between 5 to 15 rows on average. Depends on the table.

And I want to specify that each table has the same number of columns (17) with the same headers.

Here are the steps I have in mind but don't know how to do with a Power Automate Flow

1. Empty the All_Table (just in case there is old data in here)
2. Go to the first sheet with the first table
3. Copy the content of the table
4. Go to the 'All' sheet containing the 'All_Table' and paste the data there.
5. Then, do the same with all the other sheets and their respective tables but always make sure the program does not overwrite the data in the 'All_Table'.

Any idea on how I can do that with Power Automate? I don't know how to create scripts.

Was this reply helpful? Yes No
geo97 14 on at

Like (0)

Report
Copy link

Link copied!

Any idea? I still struggle 😕

Was this reply helpful? Yes No