How to Optimize Power Automate Flow for Large Excel Data (2,000+ Rows)?

(1) Share

Report

Posted on by HH-02030126-0

Hi Shifus,

I’m seeking advice on how to make this flow faster when handling large datasets (2,000+ rows). It works fine for 100–200 rows, but performance drops with more data. Are there best practices or alternative approaches for optimizing large data retrieval and processing in Power Automate?

If possible, could any shifu provide a step-by-step guide or best practices to optimize Power Automate flows for handling large Excel datasets? I’d appreciate detailed instructions or examples to help improve performance and efficiency.

Flow Description as shown:
This Power Automate flow runs weekly and retrieves quiz data from two Excel tables stored in SharePoint. It checks if each record exists in the quiz response table and adds new records if needed. After processing, it sends a report via email with the latest quiz results attached.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HH-02030126-0,

Firstly, you can turn on the Pagination and set it to something under 10,000 that reflets the data set you are collecting

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HH-02030126-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No