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.
