Dynamics 365 CE Tip of the Month: Expanding List Rows action using Pagination

When working with Dynamics 365 Customer Engagement and Power Automate, developers often face challenges when dealing with large datasets. The default 5,000 record limit on FetchXML queries can create hurdles when trying to retrieve or update large volumes of data, whether from Dataverse, SharePoint, or other connected sources. The result is often a patchwork of additional filters, complex “Do Until” loops, or multiple flows that require frequent monitoring and updates. This month’s tip focuses on a simple yet powerful feature that can eliminate these headaches: Pagination in the Power Automate List Rows action.

By enabling the Pagination feature and using OData filters within the List Rows action in Power Automate, developers can automatically page through results and return up to 100,000 records at a time. This significantly reduces the need for complex flow designs or manual intervention. With Pagination and OData filters, your flows become more efficient, scalable, and maintainable, allowing you to focus on delivering business value instead of managing flow limitations.

1. Within a Power Automate flow, select a List Rows action.
2. Make sure your filter logic is using odata filters and not FetchXML (odata filters utilize api calls that can return more than 5000 records).

3. If you need to convert FetchXML to odata, you can use the FetchXML builder in XRM toolbox to convert your query.
4. Open the settings of the list rows action.

5. Enable Pagination, and provide a threshold value up to 100,000.

6. If you’re not using variables and do not need actions to occur in sequence, you can also apply to each loop to enable concurrency, allowing up to 50 records to be processed simultaneously.

• Retrieve larger datasets across Dataverse, SharePoint, Excel, and other connectors.
• Reduce monitoring and re-runs — no more manual restarts every 5,000 records.
• Simplify Power Automate architecture by removing complex loops and custom tracking fields.
• Optimize performance with bulk record updates and concurrent processing options.

By leveraging Pagination, organizations can streamline their Power Automate flows, enabling faster and more reliable data processing. This capability not only improves performance but also supports better scalability and governance across your automation solutions.

Expanding your List Rows actions with Pagination is a simple yet impactful way to enhance how your organization handles large data operations within Power Automate. With improved efficiency and less manual oversight, your team can focus on higher-value activities that drive meaningful business outcomes. If you’re looking to optimize your Dynamics 365 Customer Engagement environment or need guidance implementing best practices in Power Automate, contact our Microsoft experts today. We can help you design efficient, scalable solutions tailored to your organization’s needs. And be sure to check back next month for our next Customer Engagement tip blog.