I'm using Power Automate to consolidate data from two Excel files into a single Excel file. My goal is to transfer data from File1 to Sheet1 and data from File2 to Sheet2 of the merged file. I utilized the "List rows present in a table" action for both files, followed by a loop to add the rows using the "Add a row into a table" action. This approach works well for smaller datasets, but when I try to process larger datasets, I encounter timeout errors due to the time it takes to complete the operation.
I'm looking for a solution that allows me to add 1000+ rows within a minute to avoid these timeout issues. Any suggestions would be greatly appreciated!

Report
All responses (
Answers (