Answered

Sum items in a gallery that updates live

(1) Share

Report

Posted on by Lewy

Hi all,

I need to add a sum column that updates as the user enters data into the gallery. Ideally once the user add new rows and enter time I would like this to update much like an excel column cell.

For example the monday column has a text box with formula in it

Sum(galleryTimeCard.AllItems,Mon)

This sums the values in the monday column but only once the output is patched. I need feedback before any patch is happened.

Summing after a patch to collection is not ideal.

The totals summing for each day currently sit outside the gallery.

Screenshot 2022-01-10 153924.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
what is the name of the mon text input as we can reference that?

e.g.
Sum(galleryTimeCard.AllItems,Value(MonTextInput.Text))

1 people found this reply helpful.

Was this reply helpful? Yes No
Lewy 34 on at

Like (1)

Report
Copy link

Link copied!

ThanksAJ_Z
it appears to work but the value changes to match the number I have just edited and is not the sum of all the columns.

Was this reply helpful? Yes No
Lewy 34 on at

Like (1)

Report
Copy link

Link copied!

I have figured it out the the gallery was incorrect hence the issue. will mark as correct thanks

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

No worries @Lewy I am happy to help wherever I can and thanks for double checking the gallery

Was this reply helpful? Yes No