How to update gallery total items count label after deleting an item ?

(0) Share

Report

Posted on by FLOWPA

Currently building a simple ticketing app.
As you can see the main page has:

Gallery containing tickets

Labels for total tickets, open tickets, and closed tickets (located within this screen OnVisible)

When I delete a ticket, the labels with Total tickets won't update (it only updates if I navigate to another screen, then back). See example below. I had 3 tickets, I deleted 1 ticket, but the labels with total did not update.

Can the label with total be refreshed and updated when a gallery item is deleted?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@FLOWPA

What are your formulas on the Text properties of the labels?

They should be CountRows(yourGallery.AllItems based.
FLOWPA 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
The screen OnVisible sets the variables for the totals:
ClearCollect(coll_GallTickets_All, Gall_TicketsList.AllItems); //ALL GALLERY ITEMS
Set(var_Ticket_CountTOTAL, CountRows(coll_GallTickets_All));

Labels all have Text set as: "Total Tickets: " & var_Ticket_CountTOTAL
@RandyHayes wrote:
@FLOWPA
What are your formulas on the Text properties of the labels?
They should be CountRows(yourGallery.AllItems based.
I tried your solution and it works, thanks for your reply.
Is there anyway I can assign variables instead? Something similar to my current setup.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@FLOWPA

Yes, so get rid of all that stuff. Variables and Collections (table variables) are all snapshots. Use them only when you need snapshots of values. Otherwise, let your controls derive their values with the formulas you provide them.

Also in general, you would want to avoid duplicating your data in the app. Your collect statement is taking a table that is in AllItems and creating an exact duplicate of that in a collection table. First, this will be a snapshot at that time only. Then your Set is just counting the rows of the table (collection).

So...to simplify, CountRows can count the rows of ANY table...and AllItems is a table.

Then your Label Text is just CountRows(Gall_TicketsList.AllItems)

If you want to determine status (I notice you have an Open and Closed label), then just filter on a value in your Gallery items.

ex. If you have a "Status" column with either "Open" or "Closed" in it, then the Open label Text property would be:

CountRows(Filter(Gall_TicketsList.AllItems, Status = "Open"))

And your Closed count label Text property would be:

CountRows(Filter(Gall_TicketsList.AllItems, Status = "Closed"))
FLOWPA 85 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes thank you!
Now, all the labels with CountRows are refreshing instantly.