Count up hours from the whole week

[TimoMigchielsen]

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: https://gyazo.com/7e36bd62fac345edec74f0dbae074559

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!

[v-qiaqi-msft]

Hi@TimoMigchielsen,

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:

Sum(
    Filter(
        '0825',
        Werknemer.DisplayName = User().FullName
    ),
    TijdTotaal
)

Best Regards,

Qi

[TimoMigchielsen]

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.