Unanswered

Count filtered rows.

(0) Share

Report

Posted on by Mirtemir

242

I am trying to count the filtered rows in my gallery. For the filter I use a dropdown that filters a choicecolumn. I want to use a textlabel to count the rows in the filter. I cannot seem to make it work. This is my latest try. What am i doing wrong?

CountRows(Filter(testList, Status.Value = DropdownStatus.Selected.Result))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (2)

Report
Hi @Mirtemir

For Gallery Gallery2.Items = Filter(testList,Title=Dropdown1.SelectedText.Value) For Label Text Label1.Text = CountRows(Gallery2.AllItems) or Label1.Text = $"Total Records: {CountRows(Gallery2.AllItems)}"

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No
Mirtemir 242 on at

Like (0)

Report

thank you, both solutions work!

Was this reply helpful? Yes No
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report

Great,

Also to be aware, the count is shown as total items rendered in the gallery, the more you keep scrolling lazyload gallery the items would keep increasing and so is the count number. hope you're aware.
thanks.

Was this reply helpful? Yes No