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 Function

(0) ShareShare
ReportReport
Posted on by 340

Hello

 

I have an app with a gallery, with data thats stored on Sharepoint. I also have a dropdown that controls my gallery.

Is there a way that when I select one of the options in the dropdown, it does a count and tells me how many there are? Kind of like a card in Power BI I guess?

 

Thank you

Categories:
  • CU-18081211-6 Profile Picture
    9,272 Moderator on at

    Hi @pricey79 ,

     

    Well you can achive that by using the OnChange property of your dropdown... 

    UpdateContext(

                     {countMySelection:

                       CountRows(Filter(yourSharepointList, yourColumn =DropDown.Selected.Value))

                     })

     

    Put a label on the Screen, set it's text property to countMySelection ...and give it a try !

     

    Hope it helps !

  • rizkyaditya Profile Picture
    292 on at

    Hello @pricey79,

    Is this what you are looking for?

    The number that tells how many filtered result are there?

    rizkyaditya_0-1604568287143.png


    If yes, then you just need to add a Label beside your Dropdown.
    And then set the Text property to :

     

    "Filtered Result : " & CountRows(YourGalleryName.AllItems)

     

    It will show you how many items are there after filtering with drop down.

     

    I hope this help!

     

    Rizky - Indonesia

  • Verified answer
    pricey79 Profile Picture
    340 on at

    @rizkyaditya 

     

    Perfect, thank you very much 

  • pricey79 Profile Picture
    340 on at

    Thank you @gabibalaban 

  • CU-18081211-6 Profile Picture
    9,272 Moderator on at

    Please mark my answer as solution if it satified your needs ! Thank's a lot !

     

    Ah ... nevermind, you have accepted another answer as solution  already.

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
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard