SharePoint Timesheet Application Development

Timesheet App Development Scope:

Power Apps

* Weekly timesheet entry screen similar to existing Excel format
* Automatically show current week (Monday–Sunday) with week navigation
* Display employee details
* Project list view
* Enter daily hours against each project
* Calculate daily totals
* Calculate weekly total hours
* Show total hours used per project
* Submit timesheet for approval
* View/update saved timesheet entries

SharePoint Lists

Master Project List

* Store all project details
* Maintain project allocation
* Track total consumed hours for each project

Timesheet Logs

* Store employee timesheet records
* Employee details
* Project
* Work date
* Hours entered
* Week details
* Approval status

Power Automate Flows

Weekly Timesheet Creation Flow

* Automatically prepares weekly timesheet records at the start of each week

Approval Flow

* Sends submitted weekly timesheet for approval
* Updates approval status

Project Hours Update Flow

* Calculates and updates total hours used against each project