Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Need help calculating non-conventional week-off



I have created a flow that fetched information from SP list and calculates if an employee has missed logging hours on daily basis and sends out an email if someone misses to log. It works fine. Now I have an issue when it comes to calculating non-conventional week-offs, like if an employee has week-off on Tuesday and Wednesday. 


I have a couple of theories but not sure if they are reliable.

1. Calculate if an employee has worked/logged for 5 continuous days, including leaves/time-offs, and consider 6 and 7th day as week-off

2. Calculate number of hours worked in a week (lets say 40 hours/week). If the count reaches 40 hours then the next 2 days are week-offs.

3. Maybe combining both the logic?  



Need some help on calculating the same. Any suggestions/help is very much appreciated.




I'd say the second option would be simpler? Can you post a picture of your flow please?



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,984)