You’re offline. This is a read only version of the page.
Announcements
4
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!
Hi,
To improve efficiency, I suggest transferring the data to CSV format. You can achieve this by using the following steps in Power Automate:
Alternatively, you can also consider using Office Scripts to optimize the process or adjusting the timeout settings to prevent errors.
If I have answered your question, please mark it as the answered and give it a Like.
Best Regards,
Eddy.
Share
Report
All responses (
Answers (
