Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Count Function



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


Accepted Solutions



Perfect, thank you very much 

View solution in original post

Resident Rockstar
Resident Rockstar

Hi @pricey79 ,


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



                   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 !

Advocate I
Advocate I

Hello @pricey79,

Is this what you are looking for?

The number that tells how many filtered result are there?


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



Perfect, thank you very much 

View solution in original post

Thank you @gabibalaban 

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.

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,506)