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?
Solved! Go to Solution.
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 !
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
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!