Skip to main content

Build an Overtime Timesheet App in Power Apps

Replace an Excel overtime timesheet with a Power Apps app on SharePoint: staff log overtime, hours are calculated and totalled for them, each department's approvers approve it in Teams or Outlook, and payroll gets a monthly Excel workbook and a Power BI report.

8 parts · 3 h 46 min read

Start with Part 1

  1. Plan the App and Set Up the Demo Organization

    · 23 min read

    Start a series that replaces an Excel overtime timesheet with a Power Apps app on SharePoint: what it does, how it's designed, what it costs, the demo organization, and the old Excel timesheet it replaces.

  2. Create the SharePoint Site and Lists

    · 23 min read

    Create the SharePoint site behind the Overtime Timesheet app: UK dates and London time, a Departments list with approvers, an OvertimeEntries list with a validation rule and indexes, and a library for payroll's workbooks.

  3. Keep Overtime Private with SharePoint Permissions

    · 20 min read

    Make SharePoint enforce the Overtime Timesheet's privacy: staff see only their own entries and can't delete them, an edited entry goes back for approval, and payroll's library is for payroll only. Then sign in as four people to prove it.

  4. Create the Solution, Environment Variables and Canvas App

    · 17 min read

    Create the Overtime Timesheet solution, four environment variables for the SharePoint site, lists and payroll library, and a responsive canvas app with modern controls, connected to the lists and to Microsoft 365 profiles.

  5. Build the Home Screen

    · 27 min read

    Build the Overtime Timesheet app's Home screen: named formulas that work out who is an approver, payroll or admin from SharePoint and Microsoft Entra groups, a responsive layout of tiles that wrap on phones, and a green theme.

  6. Build the Log Overtime Screen

    · 32 min read

    Build the Log Overtime screen: a UK date picker, searchable start and finish times, an unpaid break, hours worked out live across midnight and clock changes, checks for overlaps and unfinished shifts, and a Patch that saves each shift to SharePoint.

  7. Build the My Overtime Screen

    · 44 min read

    Build the My Overtime screen: a month of each person's overtime with status badges, the month's total and Monday-to-Sunday weekly totals, previous and next month buttons, and editing an entry on the Log Overtime screen until it's approved.

  8. Build the Approval Flow for Teams and Outlook

    · 40 min read

    Build the overtime approval flow in Power Automate: each pending entry goes to its department's approvers in Teams and Outlook, or to the person's manager, and the decision is saved on the entry, approves or rejects it in SharePoint, and is emailed to the employee.