nerdexam
Microsoft

PL-400 · Question #374

You manage a Microsoft Power Automate cloud flow. The cloud flow queries Microsoft Dataverse data by using the List rows action. You need to configure the cloud flow to process 10,000 records in a…

The correct answer is B. Return the first 5,000 records and use the @odata.nextLink in the response to return the D. Turn on pagination and set the threshold to 10,000. To retrieve 10,000 Dataverse records, you can either manually page using the @odata.nextLink property for batches of 5,000, or enable Power Automate's built-in pagination with a threshold.

Submitted by packet_pusher· Apr 18, 2026

Question

You manage a Microsoft Power Automate cloud flow. The cloud flow queries Microsoft Dataverse data by using the List rows action. You need to configure the cloud flow to process 10,000 records in a single run. What should you do? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

  • ASet the row count parameter to 10,000.
  • BReturn the first 5,000 records and use the @odata.nextLink in the response to return the
  • CCreate the query by using FetchXML and set the top parameter to 10,000.
  • DTurn on pagination and set the threshold to 10,000.

How the community answered

(38 responses)
  • A
    8% (3)
  • B
    76% (29)
  • C
    16% (6)

Why each option

To retrieve 10,000 Dataverse records, you can either manually page using the @odata.nextLink property for batches of 5,000, or enable Power Automate's built-in pagination with a threshold.

ASet the row count parameter to 10,000.

Setting the row count parameter to 10,000 (equivalent to $top) will still only return a maximum of 5,000 records per request due to the Dataverse API's default limit, requiring further pagination.

BReturn the first 5,000 records and use the @odata.nextLink in the response to return theCorrect

The Dataverse List rows action has a default limit of 5,000 records per request. To retrieve more than 5,000 records, the @odata.nextLink property provided in the response must be used in a loop to fetch subsequent batches of records until all desired records are retrieved.

CCreate the query by using FetchXML and set the top parameter to 10,000.

While FetchXML can specify a 'top' parameter, it does not override the Power Automate Dataverse connector's default 5,000 record retrieval limit per request, meaning pagination would still be necessary for 10,000 records.

DTurn on pagination and set the threshold to 10,000.Correct

Turning on pagination in the Power Automate connector settings for the List rows action and setting a threshold of 10,000 allows the flow to automatically handle fetching all records up to that limit. This abstracts the pagination logic for the maker, ensuring all 10,000 records are processed in a single run.

Concept tested: Power Automate Dataverse pagination

Source: https://learn.microsoft.com/en-us/power-automate/get-started-pagination

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-400 Practice