Sum of rows in a gallery

(0) Share

Report

Posted on by CodyO

391

Hey friends!
I am attempting to get a total of total hours worked in a time tracker app I am creating. As enteries are input, I would like the highlighted numbers to automatically add into a field where I highlighted towards the bottom.

The labels are text labels, and are not currently connected to sharepoint. I will need these times to patch to sharepoint at some point, which is another thing I am struggling with. Anyone have any advice? I am including the screenshot as well as the code I used to get the numbers.

Round(
 DateDiff(
 ThisItem.'Time In',
 ThisItem.'Time Out',
 TimeUnit.Minutes
 ) /60,
 2
)

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@CodyO

Try this on label outside your gallery

Sum( yourGalleryName.AllItems, Value(yourTextLabelName.Text))

Was this reply helpful? Yes No