web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Overcome Timeou...
Power Automate
Answered

How to Overcome Timeout Errors in Power Automate for Large Excel Data Migrations

(0) ShareShare
ReportReport
Posted on by 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!

Categories:
  • Verified answer
    Eddy Wu Profile Picture
    27 on at

    Hi,

    To improve efficiency, I suggest transferring the data to CSV format. You can achieve this by using the following steps in Power Automate:

    1. "List rows present in a table" to retrieve data.
    2. "Create CSV table" to convert the data into CSV format.
    3. "Create file" to save the CSV files directly into File3's Sheet1 and Sheet2.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 223 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard