Count items in a gallery

(0) Share

Report

Posted on by Sajarac

3,271

Hi there,

Quick question here?

I have a gallery with a couple of labels, one of the labels is the result of a radio button with items "Single" and "Double" I would like to add outside of that gallery to labels to show the total value of:

Total Singles :

Total Doubles:

Could someone point me in the right direction?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Community Power Pla... on at

Like (4)

Report
If the name of the gallery is Gallery1, you can (outside of the gallery) get the number of items in the gallery using:

CountRows( Gallery1.AllItems )

The AllItems here is the key as it references each "row" in the gallery. I'd imagine you could use Gallery1.AllItems and filter it before doing the CountRows() in order to see how many of each were "single" or "double".

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi sajarac
As an idea you could define a variable when each radio button is selected, then use the CountRows function to count rows in the gallery that is filtered by that variable / radio button selection?

Radio button OnSelect:
UpdateContext({ItemSelection: Radiobutton.Selected.Value})

Then the row count might be displayed in a label with Text:
CountRows(Filter(Collection, [Column used to determine Single/Double] = ItemSelection))

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Wow, thank you very much for this prompt response.

So you mean apply two filters?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (8)

Report
Yes,
But let's say your radio box (let's call it Radio1) that is within the gallery looks like this:

ie: where Items = [ "Single", "Double" ]

so your filters would be:

Total Items in the Gallery: CountRow( Gallery1.AllItems )
Num where Radio is Single: CountRows( Filter( Gallery1.AllItems, Radio1.Selected.Value = "Single" ) )
Num where Radio is Double: CountRows( Filter( Gallery1.AllItems, Radio1.Selected.Value = "Double" ) )
You'll want to double check the syntax in the filter, but I believe this is correct.

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (1)

Report

Thank you very much for your prompt response!!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Glad to be of help. I was working in a gallery this evening (see my other post) and this was easy for me to try at the time. 🙂

Was this reply helpful? Yes No
JuliusDoldPP 2 on at

Like (0)

Report

Its countRows instead of countRow 😉

Was this reply helpful? Yes No
Benkex 2 on at

Like (1)

Report

Gallery1.AllItemsCount

1 people found this reply helpful.

Was this reply helpful? Yes No