Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

How to calculate hours by week

I have a SharePoint list.

People fill out a form with basically tasks they did, the week ending dates and # of hours... some may only do 1 task and others may do multiple.

In my power app I want to show cumulative hours by week ending in either a gallery or data table or something.

I've been playing around trying to use "Distinct" and filtering on user().Fullname... but this doesnt seem to work.

Do I need to do some sort of collection? Or something?




Super User II
Super User II


You could use the GroupBy() function to separate out the Week and Worker, I tend to use this in the form of a gallery/subgallery.  For the documentation of the GroupBy() function see 

For examples see 

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,479)