Show number of items in a gallery based on text in SP column

(1) Share

Report

Posted on by JimboSey

321

Hello,

I have a gallery linkining to my SP list, which contains a choice 'Status' column. The three choices are 'Not Started, 'In Progress' and 'Complete'.

The idea is I will then be able to have another label to show % of complete.

I have a label (outside of the gallery) to count all rows in the SP list.

What id like is another label that shows the number of rows in my 'Status' column that are marked 'Complete'.

How would I achieve this?

Thanks

Jamie

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@JimboSeyon the labels text properly use

CountRows(Filter(your data source,Status.Value = “completed”))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (1)

Report

CountIf(MySPList,Status="Complete")

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (3)

Report

@JimboSey

Since you already have the values in your Gallery, there is no need to go back to the datasource to count information. In fact, that will reduce performance on your app as it is doing "yet another" data interaction.

So, set your label based on the values you already have in the Gallery.

Ex.

CountRows(yourGallery.AllItems)

This will provide the count of records in your gallery.

CountRows(Filter(yourGallery.AllItems, Status.Value = "Complete"))

This will provide the count of records marked as complete (assuming the Status column is a choice column). If it is not a choice column and is a text column, then change to:

CountRows(Filter(yourGallery.AllItems, Status = "Complete"))

I hope this is helpful for you.

Was this reply helpful? Yes No
JimboSey 321 on at

Like (0)

Report

This worked great, thanks @RandyHayes

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

Like (1)

Report

On my side, I have a problem on the display of the number of people in my gallery when I use CountRows(yourGallery.AllItems).

When I apply a filter, it shows me the right number, but when my list is displayed in full (more than 800 people) it shows me only 100 people in the counter, which increases by 100 if I scroll enough.
the display of the number of columns is limited to 100 if I don't scroll, no matter what I do.

How can I solve this problem ?

Was this reply helpful? Yes No