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

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates