Build Timesheet Solution with PowerApps SharePoint

Real-Life Business Solutions Series: Build your own Timesheet Management App for your Office 365 Environment
Build Timesheet Solution with PowerApps SharePoint
File Size :
7.55 GB
Total length :
13h 41m

Category

Instructor

Asif Khawaja, PhD

Language

Last update

4/2022

Ratings

4.6/5

Build Timesheet Solution with PowerApps SharePoint

What you’ll learn

Learn to create a real-life business solution with PowerApps / Microsoft Power Platform
Create free trial Office 365 E5 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

Build Timesheet Solution with PowerApps SharePoint

Requirements

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

Description

There are several courses on Udemy and all over the internet that will teach you what PowerApps is and how it works. But only a few that will teach you how to build real-life business solutions with PowerApps.In this knowledge-packed course, you will learn exactly that. You will learn and build at the same time, a real-life Timesheet Management solution with Microsoft Power Platform, specifically with PowerApps in a step-by-step way. Timesheet management solutions are very popular and in demand for all kinds of businesses and organizations. So learning, building, and implementing the solution in your company will surely be a rewarding experience.At the end of this course, you will have your very own Timesheet Management solution available and ready to deploy in your Office 365 environment. The course will also provide you with code templates, SharePoint list templates as well as partially built app templates that you can use to rapidly build the whole PowerApp and quickly deploy into your Office 365 environment.Are you excited? Now let me mention that I expect that you have already used PowerApps and are familiar with the basics. We will be touching a lot of basics and concepts but the course will not be covering too many basic details. So even if you have used PowerApps only for a little while you should be fine. So lets get started and build our real-life business solution with PowerApps.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course Outline

Lecture 3 Create Microsoft Outlook.com account

Lecture 4 Create Free Trial Office 365 E5 Tenant

Section 2: Setup Data Sources for our Timesheet Management App

Lecture 5 Section Introduction

Lecture 6 Create SharePoint site the correct way

Lecture 7 Create SharePoint lists using the provided list templates

Lecture 8 Initialize SharePoint lists with required data

Section 3: Create Timesheet Management PowerApp’s Home Screen

Lecture 9 Section Introduction

Lecture 10 Create the new PowerApp

Lecture 11 Setup App’s Start parameters

Lecture 12 Design Home Screen

Lecture 13 Add Buttons for Various Functions – Subit, View, Search, etc.

Section 4: Create Data Connections

Lecture 14 Section Introduction

Lecture 15 Create Data Connections for SharePoint Lists

Lecture 16 Create Data Connections for Outlook and Office 365 Users

Section 5: Create Submit Timesheets Screen

Lecture 17 Section Introduction

Lecture 18 Create Submit Timesheets Screen

Lecture 19 Create Week selection drop down control

Lecture 20 Calculate and Display selected week’s Start and End dates

Lecture 21 Create People Picker Control to select the timesheet Approver

Lecture 22 Filter People Picker Control

Lecture 23 Create the Collection for Timesheet Form – Part 1

Lecture 24 Create the Collection for Timesheet Form – Part 2

Lecture 25 Create the Timesheet Submission Form – Part 1

Lecture 26 Create the Timesheet Submission Form – Part 2

Lecture 27 Timesheet Form: Calculating Number of Working Hours

Lecture 28 Create the Timesheet Submission Form – Part 3

Lecture 29 Create the Save Timesheet functionality

Lecture 30 Adjust the Form for Pre-saved Timesheets

Lecture 31 Adjust the Save Timesheet functionality

Lecture 32 Create the Submit Timesheet for Approval functionality

Lecture 33 Send Email Notification to Approvers

Lecture 34 Perform Form Data Validation

Lecture 35 Create Preloader Spinner Component for Data Saving/Loading

Lecture 36 Section Conclusion

Section 6: Create Approve Timesheets Screen

Lecture 37 Section Introduction

Lecture 38 Create Approve Timesheets Screen

Lecture 39 Create Employee and Week selection drop-down controls

Lecture 40 Display selected timesheet that needs approval

Lecture 41 Create Approve functionality with Email Notification for Employee

Lecture 42 Create Reject timesheet functionality with Email Notification

Section 7: Create View My Timesheets Screen

Lecture 43 Section Introduction

Lecture 44 Create View My Timesheets Screen

Lecture 45 Create Timesheet Status and Week selection drop-down controls

Lecture 46 Display selected timesheet data

Lecture 47 Display Approver Comments for Approved/Rejected timesheets

Lecture 48 Create the Resubmission functionality for rejected timesheets – Part 1

Lecture 49 Create the Resubmission functionality for rejected timesheets – Part 2

Section 8: Create Search Timesheets Screen for App Administrators with Delete functionality

Lecture 50 Section Introduction

Lecture 51 Create the Search Timesheets Screen with Selection Dropdowns

Lecture 52 Display selected timesheet data and Approver comments

Lecture 53 Create Delete Timesheet functionality

Section 9: Integrate Timesheet Report and Create App Settings Screen

Lecture 54 Section Introduction

Lecture 55 Integrate Report button with a Timesheet data report

Lecture 56 Create Settings Screen and basic settings fields

Lecture 57 Define default Start and End Times for the Timesheets

Lecture 58 Manage App Administrators from Settings Screen

Section 10: Secure and Test the Timesheet App with End-to-End test data

Lecture 59 Section Introduction

Lecture 60 Secure the App from Unauthorized Access

Lecture 61 Test with a full timesheet workflow

Section 11: Export and Deploy Timesheet Management solution in your Office 365 tenant

Lecture 62 Section Introduction

Lecture 63 Export Timesheet Management App

Lecture 64 Export SharePoint List Templates

Lecture 65 Deploy the solution to your production Office 365 environment

Section 12: Extra Section: Rapidly Build and Deploy Timesheet App with Provided Templates

Lecture 66 Section Introduction and Lecture Resources

Lecture 67 Create a SharePoint Site (Section 2 Lecture 6 or Section 11 Leture 65)

Lecture 68 Create SharePoint lists using the provided list templates (Section 2 Lecture 7)

Lecture 69 Import Timesheet Management Skeleton PowerApp to your Office 365

Lecture 70 Update Data Connections for the App

Lecture 71 Patch Code for various App Screens and Buttons

Lecture 72 Setup Initial Data and Settings for the PowerApp

Lecture 73 Test with a full timesheet workflow

Lecture 74 Get the Full Official Ready-to-deploy Timesheet Management Solution Package

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

Course Information:

Udemy | English | 13h 41m | 7.55 GB
Created by: Asif Khawaja, PhD

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top