Power Automate

Flow to get rows from Dataverse having more than 200000 records

(0) Share

Report

Posted on by Sam70

285

Hello Team,

I need a flow which can pull data from a Dataverse table having more than 200000 rows.

Please help on this.

Regards

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sam,

Can you explain the business process where you need to get 200000 rows? Is the purpose about data integration? Will this be a one-time flow, or do you need to run it regularly? What exact help do you need from the community?

Was this reply helpful? Yes No
Sam70 285 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

It is a trigger task which will run whenever there is some change in the Dataverse table.

Regards

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you clarify the purpose behind this requirement? If a flow is triggered on every change in a Dataverse table with over 200,000 rows, retrieving the entire dataset each time is not a scalable approach and will very likely result in throttling and performance issues. Typically, flows should only process the changed record or a filtered subset of data. Can you explain why all 200,000+ rows are needed when a single row changes?

Was this reply helpful? Yes No
Sam70 285 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @David_MA,

Use case is for an ITSM environment where if any incident is crossing certain time duration (likely to breach SLA), should trigger the automation flow and email to the engineer.

if I am missing anything please let me know or any alternative approach that you can suggest.

Regards

Was this reply helpful? Yes No
André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sam,

Thanks for the clarification. When reading your initial question and your last reply, you now clarified the details of the required flow a bit. In this case, you need only one record instead of all 200K at a time, correct?

As asked before; What exact help do you need from the community? Are you new to Power Automate flow, or do you want to learn how to set the trigger for incidents with a specific duration?

Was this reply helpful? Yes No
Sam70 285 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @André Arnaud de Calavon,

You are right—I am relatively new to both Power Automate and the Dataverse environment. I created the flow, and while it completed execution, it failed when processing around 50,000 rows.

Currently, the main issue I’m facing is that during execution, the flow throws an error indicating that it cannot process more than 50,000 rows.

I have implemented two types of flows:

Trigger-based Flow:
This flow is triggered when a row is updated based on specific criteria, and it sends an email notification.

Scheduled Flow:
This flow runs every hour and updates a separate table. For example, it calculates incident counts based on priority levels and writes the aggregated results to another table at a defined frequency.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I think you'll have throttling issues trying to update 50,000+ rows every hour. But, to get more rows you will need to use pagination. You can read this blog post for some tips: Power Automate flow with pagination for 100k or more records | by Ema Myrtollari | Medium.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sam,

My guess is that your first flow is working correctly? Or do you also need some additional help here?

For the second flow, I think I would choose another option or technology.

Other option: use fetch XML to read aggregated data instead of the whole table contents row by row.

Other technologies: You can think of e.g. Azure Functions or in case you have the Fabric link enabled for you incident table you can use a Data Flow or Spark to build an aggregated reporting table.

Was this reply helpful? Yes No
Sam70 285 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks. Let me work on the suggestions.

Regards

Was this reply helpful? Yes No