CDS ‘List Record’ action limitations : Power Automate

We use ‘List Record’ action on an entity to retrieve multiple records . By default, This action retrieves maximum of 512 records. The flow would run successfully even if we have more records, but, it will return only the first 512 and skip other records.

We came across this scenario and we didn’t realize that it is skipping records. Later , we adjusted the setting to resolve this issue. Here are the steps.

if we have premium plan like power apps plan 1, power apps plan 2 and other, we can increase the limit up to 100000.

By default, Pagination is off. Switch it on and adjust the limit.

As you can see above, the maximum limit is 100000( connector attempts to retrieve data in 512 record sets ).

If we have more than 100,000 records, we will face the same issue. So it is always better to filter the record set as per our need.

It is very important to keep this limitation in mind while using ‘List Record’ action, so that we can avoid major issues in production.

Read more on limits and configuration in Power Automate here.

Original post is from my blog : https://powerofpowerplatform.com/cds-list-record-action-limitations-power-automate/