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.
To process 10,000 records in a single run for a Microsoft Power Automate cloud flow using the List rows action with Microsoft Dataverse, two approaches are appropriate. First, return the first 5,000 records and use the @odata.nextLink in the response to fetch the remaining records, ensuring efficient handling of large datasets. This method allows continuation of data retrieval, overcoming record limits in a single query. Second, enabling pagination and setting the threshold to 10,000 ensures that multiple pages of records are processed seamlessly in a single run without exceeding individual query constraints. These methods collectively support the goal of processing 10,000 records in one flow execution.
B & D provide a way to handle large datasets efficiently by processing records in batches, ultimately achieving the goal of processing 10,000 records in a single run.
Should be C https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows?tabs=classic-designer#fetch-xml-query
correction: C and D
Option C suggests creating the query using FetchXML and setting the top parameter to 10,000. While this approach is valid for limiting the number of records returned by the query, it does not directly address the requirement of processing 10,000 records in a single run. The top parameter in FetchXML limits the number of records returned in the initial query response but doesn't inherently ensure that all 10,000 records are processed within one run of the flow. Additionally, setting the top parameter to 10,000 may not be supported if the service's maximum query result size is lower.
Max limit for top is 5000, taking from MS docs: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/reference/fetch top No Positive integer value to specify the number of records to return. This value can't exceed 5,000. Don't use top together with the page, count, or returntotalrecordcount attributes. Using OData.nextLink will work for sure. It's all you need.
Correct! B and D
It is "a single run", only C & D