Answered

Gallery Count for each item

(0) Share

Report

Posted on by ecubugg

Hello! I have an app similar to a help desk where there are tasks with a specific status. The status is on a sharepoint list using the multiple choice option. There is "To Do, In Progress, Published". I want the gallery to show the count of the rows. I cannot figure out how to change the text so that it shows the count for each one. Is this possible using the gallery?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Yogesh Murugan 451 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Try this method;
First get Counts into Set variable

Set(VarCountTo-DO,Count(Filter({YourDataSource},{ChoiceFiled}="To Do"))); Set(VarIn Progress,Count(Filter({YourDataSource},{ChoiceFiled}="In Progress"))); Set(VarPublished,Count(Filter({YourDataSource},{ChoiceFiled}="VarPublished")));

Create one collection for Status

Clearcollect(ColStatus,{Status:"To Do",Count:VarCountTo-DO},{Status:"In Progress",Count:VarIn Progress},{Status:"Published",Count:VarPublished})

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. , please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ecubugg ,

If you have a label control outside Gallery then you can check the total rows current in your Gallery as

CountRows(Gallery1.AllItems)

If you have label controls outside Gallery where you need to display other count of records in database with respect to each status

Try following:

Filter( <dataSource>, <ChoiceField> = "In-Progress" ) //Add respective status

Hope this helps

Was this reply helpful? Yes No
ecubugg 49 on at

Like
a
(1)

Report
Copy link

Link copied!

Amazing! Thank you! This worked perfectly.

Was this reply helpful? Yes No