Evaluating bids

Develop a Microsoft Power App for Scheduling Days An Employee Cannot Work

Published on the June 24, 2026 in IT & Programming

About this project

Open

We are seeking an experienced Microsoft 365 developer to create a secure employee self-scheduling request system. This application will serve approximately 120 Emergency Department EMTs and Paramedics, replacing our current manual paper forms and email-based scheduling requests with a centralized digital solution. The system will allow employees to submit their scheduling preferences before each 8-week schedule is finalized.

Key functionalities include:

Employee Interface:
*  Employees must be able to securely access and edit only their own scheduling submissions.
*  The system should collect comprehensive employee information, including name, FTE (Full-Time Equivalent), role, and seniority.
*  Employees will submit up to eight 'X Days' (days they are absolutely unavailable to work) per 8-week scheduling block.
*  The system must allow for vacation requests.
*  Employees will indicate preferred shift start times from a predefined list (0700, 1000, 1200, 1600, and 1900).
*  Preferred workdays can be indicated as a preference, not a guarantee.
*  A field for additional scheduling comments will be necessary.

Scheduler and Manager Dashboard:
*  Schedulers and managers require full access to a master dashboard that automatically populates with all employee submissions.
*  The dashboard must support robust filtering and reporting capabilities.
*  Essential features include conflict detection and the ability to export data to Excel.

Scheduling Rules and Logic:
*  The scheduling block is defined as eight weeks, with work weeks running from Saturday through Friday.
*  Employees are limited to a maximum of eight X Days per 8-week scheduling block.
*  No more than four consecutive X Days can be requested within a single work week to prevent extended absences.
*  Holidays must be excluded from selection as X Days.

Conflict Detection and Highlighting:
*  The scheduler dashboard should prominently highlight potential conflicts, including vacation overlaps, conflicting or overlapping X Day requests, and instances where employees have not submitted their requests.
*  The system should also identify other general staffing conflicts based on the collected data.

Technical Requirements:
*  The ideal solution will leverage Microsoft 365 tools, such as Power Apps, Microsoft Lists, SharePoint, or similar components within the M365 ecosystem.
*  The application must feature a clean, professional, and mobile-friendly user interface to ensure ease of use for both employees and schedulers.

Category IT & Programming
Subcategory Web development
What is the scope of the project? Create a new custom site

Delivery term: Not specified

Skills needed