web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Creating an overtime s...
Power Apps
Unanswered

Creating an overtime system

(0) ShareShare
ReportReport
Posted on by 15

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.

Categories:
I have the same question (1)
  • mmollet Profile Picture
    3,187 on at

    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 Profile Picture
    15 on at

    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

  • Verified answer
    mmollet Profile Picture
    3,187 on at

    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: 

    Screenshot 2023-05-05 at 9.15.03 AM.png

     

    User Profile:

    Screenshot 2023-05-05 at 9.17.56 AM.png

     

    Clock In/Out: 

    Screenshot 2023-05-05 at 9.19.32 AM.png

     

    Screenshot 2023-05-05 at 9.18.35 AM.png

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard