Power Platform Community Forum Thread Details

Hi. I have a timesheet app that works great with around 10 people entering their working hours on a daily basis. The timesheet is cleared down at the end of each week. I would like to add a summary page view that displays the total hours worked for each individual in the week. The 2 fields I have are 'Name' and 'Hours'. Using the groupby method I have a screen that lists each person with one or more entries in the excel data. However when I try to show the 'Hours' field it is blank and shows an error. I have tried the sum(thisitem.hours) command but it also gives an error. I use the following to total everyones hours:

 
"Total Hrs "+Sum(BrowseGallery1.AllItems, Hours). This formula works great for the total of all entries, but not for each individual.
 

What formula do I have to enter so that each persons total hours for the week is displayed? Thanks in advance.

Categories:

Building Power Apps

Community site session details

Calculating summary totals

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates