Merging multiple excel files with same Table setup into one master file

(0) Share

Report

Posted on by mendez2587

Hello,

So I have 6 Excel files and 1 master list. They all have the same column headers and they are all tables built identical. I've been trying to figure out a way to merge all the data into one master file. It's a hit or miss at times. I've been able to get the data transferred over from one file just to run tests. But the information never stops replicating it'll just keep going on and on.

Files are all located in SharePoint.

Columns I have are : Directorate, Department, Title, LastName, FirstName, Status, Date, Time.

I'm trying to make this a reoccurring task every day at 0830 M-F and once the data has been merged for it to send an email attachment.

Any help would be appreciated. I've been over tons of videos and just constant reading but being new to Power Automate it's so stressful.

All responses (4)

Answers (0)

claudiovc 94 on at

Like (0)

Report

Re: Merging multiple excel files with same Table setup into one master file

try this please
lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Re: Merging multiple excel files with same Table setup into one master file

For these low row counts you should be able to get away with simple array enumerations. Can you provide some sample files?
mendez2587 33 on at

Like (0)

Report

Re: Merging multiple excel files with same Table setup into one master file

Good Morning,

It varies. 11, 50, 16, 93, 61, 7.
238 rows in total.
lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Re: Merging multiple excel files with same Table setup into one master file

how many rows in each of the files?