Unanswered

Countrows Choice Column

(0) Share

Report

Posted on by Ward_1984

Hi,

I have made a app where you can see every task available. And now i want to filter these task. So i have made a disctinct collection on every column i want to filter (and added a colum so i can see wich one's are selected) en put these collections in a gallery. So i can create the folowing picture

So far everything works and i can select the column and the filter does it job.

But the problem lies in the Status column (sharepoint Choice column). On the picture you can see that there is the amount of records visible after every choice. But you can see it works on every filter except Status.

The code below generate the text. The other Filters are generated the same way.

ThisItem.Value & " (" & CountRows(Filter(galWerkbonnen.AllItems;Ploeg = ThisItem.Value)) & ")"

Thanks at advance!

Kind regards,

Ward

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Ward_1984 ,
Try using below formula -

ThisItem.Value & " (" & CountRows(Filter(galWerkbonnen.AllItems;Ploeg.Value = ThisItem.Value)) & ")"

Was this reply helpful? Yes No
Ward_1984 52 on at

Like (0)

Report
hi @NandiniBhagya20 thanks for the reply.
I apparently copy'd the wrong gallery my formula was the same:
ThisItem.Value & " (" & CountRows(Filter(galWerkbonnen.AllItems;Status.Value = ThisItem.Value)) & ")"
I also try'd hardcoding it like the following:
ThisItem.Value & " (" & CountRows(Filter(galWerkbonnen.AllItems;Status.Value = "In Progress")) & ")"
But nothing works like it should be!

Was this reply helpful? Yes No
Ward_1984 52 on at

Like (0)

Report
But if i use the formula on my sharepointlist directly it works fine
CountRows(Filter(sys_WBI;Status.Value = "In Progress"))
But from my gallery this doesn't work even if i have all my data

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Ward_1984 ,
Can you please share formula written in Items property of Gallery - "galWerkbonnen".

Was this reply helpful? Yes No