Like in Dynamics 365, you see a total number of records under a view. And you want similar in a Canvas PowerApp too.


Here’s a simple tip to do so –

CountRows() method

It’s pretty simple. Using CountRows(source) method, you can get the count of records in the Source. In this case, it’s the CDS entity Accounts.

To flourish how I display the count, I use the Concatenate() method and then use CountRows() inside it first show the text and then the actual count.

Please note that this goes without filtering out any criteria and straight count of how many records the connection has. Your gallery could use more filtering to display lesser records if specified that way.

Handle Delegation

However, you need to handle a few things if you’re aware that your dataset is large.

Using this formula will give a warning:

And the general help offered is this –

Refer this article to understand more: https://powerapps.microsoft.com/en-us/blog/powerapps-data-row-limit-for-non-delegable-queries/

Hope this quick tip helps!

Here are some more Canvas PowerApp / Power Automate posts you might want to look at –

1. Dependent OptionSets in a Canvas Power App for 1:N related CDS entities | Power Platform
2. Restore older version of a Canvas Power App | Power Platform
3. Implement character length validation in a Canvas Power App | Power Platform
4. Logged In User details in a Canvas Power App
5. Implementing Exit app, Logout and Confirm Exit features in a Canvas Power App
6. Variables in Canvas Power Apps | Global and Context
7. Get N:N records in a Canvas Power App using Common Data Service connector | Power Platform
8. Get Count of records retrieved in CDS connector in a Flow | Power Automate

Thank you!