Power Platform Community Forum Thread Details

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.

Categories:

Building flows