Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Count up hours from the whole week

Hello there!

I want to calculate all of the hours an employee makes every week. How can I sum up all of the hours? We need to filter the user his username.

In powerapps I am setting the variabele varcurrectuser to the user their fullname.

Picture of my database UrenRegistratie:

We need to filter it where varcurrentuser = werknemer. 
We then need to sum up all of the hours in TijdTotaal column

Thank you for your reply in advance!

Community Support
Community Support


Based on the issue that you mentioned, do you want to sum up all the hours the current user made in a week?

Could you please share a bit more about your scenario, what is the column type of 'TijdTotaal' and 'Werknemer', Number and Person?

I have a test on my side, here is my scenario:

  • I have a SharePoint list containing 'TijdTotaal' and 'Werknemer', they are Number column and Person column

Add the Office365Users connector within your app.

Add a Label and set the Text property as below:


        Werknemer.DisplayName = User().FullName



Best Regards,





Thank you for your reply! @v-qiaqi-msft 

That has done the trick but counts up all of the hours in total. There is a delegation error though (I use SharePoint)

Are you able to make it using a variabele? I have 3 buttons, day, week & month. The day sets the variabele to 1, the week sets it to 8 and the month sets it to 32. 

I'd like to have use this variabele to only sum up the total time for just "today", the past week & or the whole month, which ever button is pressed. 

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (2,193)