How to calculate hours by week

[Mattw112IG]

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?

Thanks,

Terry

[Drrickryp]

@Mattw112IG 

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

 https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby 

For examples see

 https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/PowerApps-Gallery-SubGallery-using-Gr...