Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master PowerApps: Build a Timesheet Solution Step-by-Step

Name: Master PowerApps: Build a Timesheet Solution Step-by-Step
Rating: 4.6 (852 reviews)

Create a real-world Power Apps solution for timesheet tracking with seamless SharePoint & Microsoft 365 integration

Highest Rated

Created byAsif Khawaja, PhD

Last updated 2/2025

English

German [Auto],English [Auto],

What you'll learn

Learn to create a real-life business solution with PowerApps / Microsoft Power Platform
Create a trial Office 365 tenancy (if you don't want to experiment in your production tenancy)
Prepare data sources for the Timesheet Management PowerApp solution with provided SharePoint list templates
Create required SharePoint lists, initialize necessary data, and create data connections for the PowerApp
Create the Timesheet Management PowerApp's landing screen with buttons for different functions
Create the Timesheet Submission screen and submission form - select a week, select an approver, fill timesheet and submit
Create the View My Timesheets screen - to allow the employees to view their own timesheets securely
Create the Approve Timesheets screen - to allow the managers/approvers to approve timesheets
Create email notification functionality - to send automatic emails to approvers and employees
Create the Search Timesheets screen - to allow the app admins or Payroll officers to search all employees' timesheets
Create People Picker control for Approver and Admins searching and selection
Create the Delete timesheets functionality for the App admins
Create the Timesheet Reporting function - to allow the app admins or Payroll officers to reprot on all timesheets
Create the App's Settings screen - to allow the app admins to configure various settings of the app
Use variables, collections, galleries, tables, forms, data connections, and various PowerApps functions to build the whole solution
Integrate Timesheet Reports with the PowerApp
Test the Timesheet App with test data and end-to-end timesheet submission and approval workflow
Export and deploy the Timesheet Management solution in your production Office 365 tenancy

Course content

13 sections • 82 lectures • 14h 43m total length

Introduction14:54
Learn to build a real-life timesheet management solution with Microsoft Power Apps step by step, including submission, approval, search, reporting, and administration in an Office 365 environment.
Course Outline8:01
Create Microsoft Outlook.com account3:05
Create a Microsoft account on Outlook.com to launch a free Office 365 E5 trial, enabling you to set up and use PowerApps for building a timesheet solution.
Create Free Trial Office 365 E5 Tenant (Revised 2025)13:42

Section 2 Introduction: Data Sources1:25
Section two guides you to prepare data sources for the timesheet management PowerApp by creating a SharePoint site and lists in Office 365, using the provided list templates.
Create the SharePoint site (Revised 2025)2:23
Create SharePoint lists using the provided list template files (Revised 2025)6:34
Initialize SharePoint lists with required data6:56
Initialize and populate the key SharePoint lists for the timesheet PowerApp, including timesheet administrators, employees, weekly records, details, and settings, ensuring correct admin emails and complete data for approval workflows.

Section 5 Introduction: Submit Timesheets2:48
Create Submit Timesheets Screen5:05
Create Week selection drop down control23:00
Calculate and Display selected week's Start and End dates6:29
Create People Picker Control to select the timesheet Approver11:52
Filter People Picker Control7:20
In this lecture, you will learn to filter the People Picker control to display only the active users.
Create the Collection for Timesheet Form - Part 112:10
Create the Collection for Timesheet Form - Part 214:27
Create the Timesheet Submission Form - Part 119:40
Create the Timesheet Submission Form - Part 211:09
Timesheet Form: Calculating Number of Working Hours24:24
Create the Timesheet Submission Form - Part 35:25
Create the Save Timesheet functionality26:20
Create the save timesheet feature in PowerApps, saving seven days to three SharePoint lists using collect and patch. Implement new user detection and an approver workflow.
Adjust the Form for Pre-saved Timesheets21:03
Adjust the timesheet form to load pre-saved data for the selected week instead of defaults. The lecture covers checking the weekly list, loading details, and updating the approver and status.
Adjust the Save Timesheet functionality27:21
Create the Submit Timesheet for Approval functionality15:55
Send Email Notification to Approvers23:10
Perform Form Data Validation31:54
Create Preloader Spinner Component for Data Saving/Loading21:04
Create a preloader component to protect timesheet data while loading or saving from SharePoint lists, controlled by a show preloader variable.
Section Conclusion3:21
Conclude the section by detailing the timesheet submission screen in Power Apps. Include week selection, date calculations, an approver picker, and a collection-based form with save, submit, validation, and notifications.
Share screenshots of Home as well as Submit Timesheet screens

Section 6 Introduction: Approve Timesheets1:51
Create Approve Timesheets Screen3:52
Create Employee and Week selection drop-down controls12:49
Display selected timesheet that needs approval13:20
Create Approve functionality with Email Notification for Employee33:32
Implement approve time functionality in a PowerApps timesheet app, update weekly and details SharePoint lists from submitted to approved, and email the employee with approver name and comments.
Create Reject timesheet functionality with Email Notification15:22

Section 7 Introduction: View Timesheets2:19
Create View My Timesheets Screen3:19
Create Timesheet Status and Week selection drop-down controls13:44
Display selected timesheet data5:48
Filter the timesheet gallery by the selected week and status, using the dropdown value and the current user's email to display the correct data from SharePoint.
Display Approver Comments for Approved/Rejected timesheets18:23
Create the Resubmission functionality for rejected timesheets - Part 125:11
Create the Resubmission functionality for rejected timesheets - Part 225:23
Learn to edit and resubmit rejected timesheets in PowerApps, saving changes, updating the status to submitted, and notifying approvers via email while syncing data with SharePoint lists.

Section 8 Introduction: Search and Delete Timesheets0:51
Create a search timesheets screen for power app administrators, with dropdown filters to display selected timesheet data and approval comments, and enable deleting a specific timesheet.
Create the Search Timesheets Screen with Selection Dropdowns13:21
Display selected timesheet data and Approver comments11:20
Display selected timesheet data and approver comments in a PowerApps timesheet solution by wiring dropdown filters to galleries and using the selected employee email.
Create Delete Timesheet functionality18:44
Enable administrators to delete a selected timesheet from two SharePoint lists using remove and for all. Display a preloader during deletion and hide the button when no date is selected.

Section 9 Introduction: Timesheet Report and App Settings0:58
Integrate Report button with a Timesheet data report7:30
Integrate a timesheet report button with a SharePoint data report, using the timesheet details list and the timesheet employees weekly list, and launch the report URL from the app.
Create Settings Screen and basic settings fields23:58
Define default Start and End Times for the Timesheets16:01
Manage App Administrators from Settings Screen10:54

Requirements

A basic understanding of Microsoft 365 tenant
A basic understanding of PowerApps and SharePoint Lists
An Office 365 or Microsoft 365 tenant to build the solution. We will show you how to create trial Office 365 tenant.

Description

** Course updated in 2025 **

Many courses teach you what PowerApps is, but only a few show you how to build real-life business solutions. This course takes a hands-on, step-by-step approach to building a fully functional Timesheet Management system that integrates with Microsoft 365, SharePoint, and Power Automate.

Timesheet management is a critical need for businesses of all sizes, enabling employees to track time efficiently and managers to streamline approvals. In this course, you will learn how to develop, customize, and deploy a PowerApps-based timesheet solution that automates workflows and enhances productivity.

Why This Course?

Real-world project – Learn by building an actual Timesheet Management app.
Microsoft 365 integration – Seamlessly connect with SharePoint and Power Automate.
Time-saving templates – Use pre-built code, SharePoint lists, and app components.
Practical, hands-on learning – No fluff, just step-by-step implementation.
Faster deployment – Get your app up and running quickly in your organization.

Who Should Take This Course?

PowerApps users who want to build practical business applications.
IT professionals and business analysts seeking to automate time tracking.
Developers and consultants looking to create Microsoft 365 solutions.
Organizations that need a robust timesheet management system.

If you have basic knowledge of PowerApps and want to apply your skills to a real business scenario, this course is for you. Start building your timesheet solution today!

Who this course is for:

Anyone wanting to learn PowerApps and implement the knowledge at the same time in their own production environment
Beginner PowerApps developers wanting to build real-life business solutions
Anyone wanting to learn medium to advanced concepts of PowerApps and other Power Platform tools
Anyone wanting to create business solutions using Microsoft Power Platform
PowerApps users who want to build practical business applications
Organizations that need a robust timesheet management system.

Master PowerApps: Build a Timesheet Solution Step-by-Step

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 40min

Setup Data Sources for our Timesheet Management App4 lectures • 17min

Create Timesheet Management PowerApp's Home Screen5 lectures • 26min

Create Data Connections3 lectures • 8min

Create Submit Timesheets Screen20 lectures • 5hr 14min

Create Approve Timesheets Screen6 lectures • 1hr 21min

Create View My Timesheets Screen7 lectures • 1hr 34min

Create Search Timesheets Screen for App Administrators with Delete functionality4 lectures • 44min

Integrate Timesheet Report and Create App Settings Screen5 lectures • 59min

Secure and Test the Timesheet App with End-to-End test data3 lectures • 37min

Requirements

Description

Who this course is for: