web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Count number of rows -...

Power Automate

Suggested Answer

Count number of rows - Dataverse table

(0) Share

Report

Report

Posted on by TaylorPBI21

Hey Experts,

I've connected to a Dataverse table using List Rows and want to scan the table & count the number of rows, then have this count displayed within compose. My answer should be roughly 27,000 but can't get around the 5,000 limit.

Any help would be greatly appreciated.

Many Thanks,

Taylor

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
You can increase pagination on your List Rows action but I suggest that you use the HTTP method which is more efficient than pagination, especially for large datasets, as it retrieves only the count instead of the entire dataset.

Configure the HTTP action as follows:

Method: GET

URI:
https://<your_org>.api.crm.dynamics.com/api/data/v9.0/<YourTableName>/$count
You will need a service Principal, see resources here

Tutorial: Register an app with Microsoft Entra ID (Microsoft Dataverse) - Power Apps | Microsoft Learn

Use OData to query data - Power Apps | Microsoft Learn

Was this reply helpful? Yes No

Join the conversation