You’re offline. This is a read only version of the page.
Announcements
Hey all,
I am quite new in the Power Automate world, so I think I need a little bit of advice on how to start with my problem.
My task is really simple: Combine the contents of multiple Excel files across different SharePoint folders into one.
Just as a background information, each file is used by a department and they only have the permission to work on their specific file. The master file is used by us for further automatization processes and that is the reason why changes should ideally be processed instantly into the master file.
Unfortunately I can't use PowerQuery, since the files are all located on SharePoint.
I was trying to create a workflow with the following steps:
1. Delete old master file
2. Create new master file
3. Copy and Paste each department file into master file
But I couldn't find the action in PowerAutomate to copy and paste a whole workbook. The iterative version to do this row by row is way to slow and when someone makes another change in the department flow a new flow is triggered and messes up the whole process. So ideally it shouldn't take much time.
I will be thankful for any help or ideas for different approaches.
This video shows how to insert multiple rows into an Excel workbook: How to easily export from Power Automate to an Excel file without premium actions or apply to each.
That said, I'm puzzled why you say Power Query won't work for you, Power Query is able to connect to SharePoint.
Share
Report
All responses (
Answers (
1,090
