CountRows, CountIf, CountA and Count in Power Apps

How often would you like to count the number of records without really wanting to load all the records that exist in a list or table. CountRows, CountIf, CountA and Count are four functions to get a record count in Power Apps.

Various datasources

In this post I’m going to consider both SharePoint and Dataverse only. If you use SQL you will find that a quick Stored procedure will give you the count of the records anyway.

The Count functions

Power Apps has 4 count functions that we can use to get the number of records in a list, table or collection.

• CountRows
• CountIf
• CountA
• Count

CountRows

CountRows returns the number of records in a data source.

CountRows(MyData)

CountIf

CountIf returns the number of records that match certain criteria. Settings the query to true will return all records.

CountIf(MyData, true)

CountA

CountA returns the number of records that don’t have a blank value in a single text column. Empty text values “”, are considered not blank.

CountA(MyData.TextField)

Count

The Count function counts the number of records that contain a number in a single column.

Count(MyData.ID)

Using the count functions in SharePoint

Now that we understand the various count functions, I’m going to use them on a SharePoint List with thousands of records.

Using Power Automate or reading the data in a collection is of course an option. The code as shown below could work, however loading all the data into your app might not be very memory efficient.

ClearCollect(colData, MyList);
Collect(colData, Filter(MyList, Created > Last(colData).Created));
Collect(colData, Filter(MyList, Created > Last(colData).Created));
Collect(colData, Filter(MyList, Created > Last(colData).Created));
Collect(colData, Filter(MyList, Created > Last(colData).Created));
Collect(colData, Filter(MyList, Created > Last(colData).Created));
CountRows(colData);

Using the count functions in Dataverse

If we now switch over to Dataverse we will find completely different results.

Of course it is great to see that CountIf gives me the right number of records in my table. The number of records however is limited to 50000. If you need to get a higher number of record count back then you might need to look into the workaround mentioned in the SharePoint section of this post.