How to Handle Over 100,000 Rows in Power Automate List Rows Action for Dataverse?
Table of Contents
Question
You create a Power Automate flow that gets data from Dataverse by using the List rows action and its rows filter capabilities.
With the filtering you need to apply, the result may contain more than 100,000 rows.
You need to ensure the flow can handle all the results.
Which three actions should you perform? Each correct answer presents part of the solution.
Select all answers that apply.
A. Add a new string variable to store the skip token.
B. Activate pagination on the List rows action.
C. Create a do-while loop for as long as the skip token variable is not empty. Add the list row to the loop and use the stored skip token.
D. Add a new Boolean variable to store more records.
E. Fetch the skip token from the List rows action and store it in another variable.
Answer
A. Add a new string variable to store the skip token.
C. Create a do-while loop for as long as the skip token variable is not empty. Add the list row to the loop and use the stored skip token.
E. Fetch the skip token from the List rows action and store it in another variable.
Explanation
This item tests the candidate’s knowledge of Power Automate development patterns as well as limitations of the Dataverse connector.
To get more than 100,000 rows, you cannot use the OOB pagination. You need to implement a loop to fetch new rows as long as the skip token is not empty. You also need to extract the skip token from the response to be able to skip the already processed rows.
Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.