Creating an overtime system

[SebastianSzyrok]

Hello :),

I wonder if I am able to create an overtime system for my employees in Power Automate. The point is that I can add employees + assign them (manually) how many days they have to choose from, then the employee creates an application, e.g. in sharepoint lists, and days after my approval of the application are subtracted from this pool of days off. Has anyone done something like this or have an idea how to do it? I count on your support and creative ideas.

[mmollet]

I just developed a full scale clock in/out application to track time including OT and driving time etc. I use Power Automate and excel to generate bi-weekly reports of the each employees hours worked, mileage driven, and hours per task. You can definately create what you are talking about using Power Apps and Power Automate we just need to figure out the best way to do it first. Before that I want to make sure that I understand what you are asking for. Can you explain if say Bob wanted to get some overtime what would the process be? From what you have said I have gathered this:

You will assign them how many days they have to choose from. (Not sure what you mean by this tbh)

The employee will create an OT request/application to submit that will have to be approved by you.

The pool of days off lost me as well. You are talking about OT then all of the sudden on days off which is the opposite. 😛 Im 100% sure we can get your issue figured out once I understand what is going on.

[SebastianSzyrok]

Hi, thank you for your answer and I'm translating now:

- Employee Bob comes to work on Saturday, which means he works 6 days a week, not 5
- in the application that I will create, I would like to be able to enter this 1 day for such an employee as a day to pick up (holiday)

- the employee sees how many days he has to choose
- when he decides to collect on such a day, he completes the application and sends it for approval

- the designated person (supervisor) approves such a day
- from 1 day off for the employee, Bob becomes 0 days off
- when the employee has worked more days again, I can add another day off and the process repeats

[mmollet · Accepted solution]

Ooooh ok so employees earn time off when working overtime in essense. They can then use this time once it is approved. This is what you would like to track. This is def doable and I have done similar things in the past. Here is the layout/screens I used and we can go from there. 

Home Screen - this screen just tells the user who is logged in and also lets them choose from an array of buttons that take them to other places in the app.

User Profile - this screen shows the user totals such as hours worked etc and in your case will be their HUB for how much time off they have. Generally I also display a gallery that holds the user's past/current time entries but in your case it would be past/current time off requests and their dates and status.

Admin Screen - this screen will only be accessable for certain users such as yourself. This is where you will be able to do admin type functions such as add time off to someone profile or accept a time off request etc. This is also generally where I put any buttons for admins to run Power Automate flows to generate any reports they may want etc.

User Submit Request - this screen will be where your end users are able to submit a time off request from the app. This will allow them to select dates/times, number of hours, and whatever else you want to or need to track. 

This is a good starting point for an app like you are talking about. I will show you some images of the last one I did that was time tracking. This app is used to track how many hours are worked per day and how many of those hours were for each project as projects are billed for their hours. 

Home Page: 

User Profile:

Clock In/Out: 

Hope this helps or at least gets the cogs turning for you! =^D