title | description | author | ms.topic | ms.custom | ms.reviewer | ms.date | ms.subservice | ms.author | search.audienceType | contributors | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Count, CountA, CountIf, and CountRows functions |
Reference information including syntax and examples for the Count, CountA, CountIf, and CountRows functions. |
gregli-msft |
reference |
canvas |
mkaur |
6/10/2024 |
power-fx |
gregli |
|
|
Applies to: :::image type="icon" source="media/yes-icon.svg" border="false"::: Canvas apps :::image type="icon" source="media/yes-icon.svg" border="false"::: Desktop flows :::image type="icon" source="media/yes-icon.svg" border="false"::: Model-driven apps :::image type="icon" source="media/yes-icon.svg" border="false"::: Power Pages :::image type="icon" source="media/yes-icon.svg" border="false"::: Power Platform CLI
Counts all records in a table, or counts all records that satisfy a condition.
The Count function counts the number of records that contain a number in a single-column table.
The CountA function counts the number of records that aren't blank in a single-column table. This function includes empty text ("") in the count.
The CountIf function counts the number of records in a table that are true for a logical formula. The formula can reference columns of the table.
The CountRows function counts the number of records in a table.
Each of these functions returns a number.
You need to enable the Enhanced delegation for Microsoft Dataverse option in the advance settings to make CountIf and CountRows functions delegation to work. To enable the option:
-
Open the app where you want to use the functions.
-
Select Settings > Upcoming features > Preview.
-
Turn on the Enhanced delegation for Microsoft Dataverse option.
Important
- There is a 50K delegation limit if you use
CountRows
andCountIf
functions with filters. There is no hard limit on theCountRows
function when extracted directly from the data source because of the cached count that Dataverse keeps. - If the
CountRows(<Data Source>)
function is used without filtering, the count might not be 100% accurate, because the cached count updates periodically. If you need precise count and expect the result to be under the aggregate limit, you can bypass the cached count viaCountIf(<Data Source>, True)
.
Count( SingleColumnTable )
CountA( SingleColumnTable )
- SingleColumnTable - Required. Column of records to count.
CountIf( Table, LogicalFormula )
- Table - Required. Table of records to count.
- LogicalFormula - Required. Formula to evaluate for each record of the table. Records that return true for this formula are counted. The formula can reference columns of the table.
CountRows( Table )
- Table - Required. Table of records to count.
-
Import or create a collection named Inventory, as the first subprocedure in Show images and text in a gallery describes.
-
Add a label, and set its Text property to this formula:
CountIf(Inventory, UnitsInStock < 30)
The label shows 2 because two products (Ganymede and Callisto) have fewer than 30 units in stock.
-
Add another label, and set its Text property to this formula:
CountA(Inventory.UnitsInStock)
The label shows 5, the number of non-empty cells in the UnitsInStock column.
-
Add another label, and set its Text property to this formula:
CountRows(Inventory)
The label shows 5 because the collection contains five rows.
[!INCLUDEfooter-include]