Unanswered

Calculate monthly work hours based on weekly time tracking table

(0) Share

Report

Posted on by Evastor

Hello,

In power apps I've build a simple app for time tracking purpose where employee can put his/her hours based on weekstart date. Now my Sharepoint list looks like this:

I wonder if it's possible to sum each month based on those weekly records? In this example the week starts at 19.02.2024, so it means that Monday is 19.02, Tuesday is 20.02 etc. Flow should go through whole list (fitlered by project ID) and then somehow calculate each month and provide results to Power Apps.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report

@Evastor

I know I am not going ot be able to help you but I am trying to clear up the maths side of thing.

Line one in you example adds up to 80.5 hours for that week with line two at 36 hours. You may have another 20 items for more projects with multiple employees working on them. I think you are saying you want the total hours per project for each week.

If that is the case then you will need the total for the week hours, before you can even start the above. I would use a calculated column in the list to do that But how to get from that total per item to what you want I cannot help you with. But have a look at the below that might give you some pointers.

https://www.youtube.com/watch?v=e8gKLBDHQHc

Regards,

Andrew

Was this reply helpful? Yes No
Evastor 2 on at

Like (0)

Report
This is not entirely what I have in mind. The idea is for Power Automate to check for each day of the week in a month based on the date from "WeekStart". In the example under consideration, we will have:
"Mon" as 19.02
"Tues" as 20.02
"Weds" as 21.02
"Thurs" as 22.02 ...
"Sun" as 25.02
Having a month for each day of the week for each item on SharePoint, I would like Power Automate to ultimately sum all the hours for January, February, March, etc., until the end of the year for a specific project, and send these results to Power Apps.
The trigger for the entire flow will be PowerApps, where the "ProjectID" will be sent.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@Evastor

Looking at the above, I really cannot help anymore as it very confusing to me and I will be on leave tomorrow so will have to leave it to others.

Andrew

Was this reply helpful? Yes No