Count Function

(0) Share

Report

Posted on by pricey79

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

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 !

Was this reply helpful? Yes No
rizkyaditya 292 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Verified answer

pricey79 340 on at

Like (0)

Report

@rizkyaditya

Perfect, thank you very much

Was this reply helpful? Yes No
pricey79 340 on at

Like (0)

Report

Thank you @gabibalaban

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No