web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

Count List

(0) ShareShare
ReportReport
Posted on by 162

Good Day!

How to count All list of Datatable based on Filter



thanks and advance

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @DHAGZ 

    Wrap the Items property of the datatable in CountRows(). Put that formula in the Text property of a label.

  • DHAGZ Profile Picture
    162 on at

    @Drrickryp  how ?

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Please show the Items property of your datatable with the Filter().

  • Verified answer
    v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @DHAGZ ,

    What do you want to count?

    Do you want to count the number of the filtered items from a datasource?

    If yes, as @Drrickryp suggested , you can use CountRows() function.

    For example, I have a SharePoint list with a "Brand" column, I want to count the number of items with a particular brand(like "Apple"), so I can add a label control, then set its Text property to this(replace to your DataSource name):

    CountRows(Filter(DataSourceName, Brand="Apple"))

    v-albai-msft_0-1619597543809.png

    You can also use this formula, both gets count number successfully:

    CountIf(DataSourceName, Brand="Apple")

    v-albai-msft_1-1619597668567.png

     

    Note: If your DataSource is also a SharePoint list like my example, above formula may cause Delegation issue, you could consider to save your SPList into a Collection, then use the Collection as data source within your formula.

    You can refer to Example section mentioned in this article to learn more about how to "count all records in a table, or count all records that satisfy a condition":

    Count, CountA, CountIf, and CountRows functions - Power Apps | Microsoft Docs

    Best regards,

    Allen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 396 Most Valuable Professional

#2
11manish Profile Picture

11manish 134 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 101 Super User 2026 Season 2

Last 30 days Overall leaderboard