Facility Maintenance & Work Order Management System For Transcend Maintenance Services, Inc.
1. Application Overview The Employee Supply Request Power App is designed to provide employees with a structured digital process for submitting supply requests from their job sites. Through the application, employees can enter their details, add multiple requested items, upload supporting photos, and submit the complete request through a single process. Once submitted, the application generates a unique tracking number, stores the request information in SharePoint, and sends the request details through Microsoft Teams with an optional email notification. The stored request data can also be exported to Excel for record-keeping and analysis. 2. Supply Request Management Employees can create a new supply request by entering the required information, including: Employee Name Job Site Item Details The application allows multiple supply items to be added dynamically within the same request. Employees can review the added items as a list before submitting the request. When the request is submitted, the system automatically generates a unique tracking number that can be used to identify and track the submission. 3. Photo Upload The application allows employees to provide supporting photos as part of the supply request process. A photo upload prompt is presented during the request process for the required janitorial closet photo, and uploaded photos are linked with the relevant request. The request structure also supports a supply label photo against individual requested items. 4. Request Submission and Tracking Once all required information has been entered, the employee submits the request through the application. On submission, the system compiles the entered information and generates a unique tracking number for the request. This tracking number serves as the Request ID and links the main request with its associated supply items. This provides a structured method for maintaining both the overall request information and the individual items included within each request. 5. Microsoft Teams and Email Notifications Submitted requests can automatically be communicated to the designated team through Microsoft Teams . The application formats the request information into a structured Teams post so that the receiving team can easily review the submission. Users can also use an optional email notification, including notifications to multiple recipients where required. Notifications can include a summary of the request together with a link to the relevant submission. 6. Request Data Storage All submitted request information is stored in SharePoint . The main request stores information such as: • Request ID / Unique Tracking Number • Employee Name • Job Site Name / Number • Submission Date Individual requested items are maintained separately and linked back to the main request through the Request ID. Each item record can include: • Item Name / Description • Photo of Supply Label • Timestamp of Item Entry This structure allows the main supply request and all associated items to be retrieved and managed together. 7. Request Updates and Data Retrieval Stored requests can be updated when corrections are required or when additional items need to be added. This allows request information to remain maintainable after the initial submission rather than requiring a completely new request for every correction or addition. 8. Excel Export and Reporting Supply request information stored in SharePoint can be downloaded as an Excel file . This provides an accessible way to use submitted request information for record-keeping, reporting, and further analysis outside the application. 9. Testing and Validation The application includes functional testing of the individual modules as well as integration testing for Microsoft Teams and email notifications. Testing is intended to verify that the application features, request submission process, data storage, and notification functions operate correctly before final implementation. Overall Application Workflow The process begins when an employee opens the Power App and creates a new supply request. The employee enters their name and job site information, adds one or more required supply items, and provides the required supporting photos. Once the request is submitted, the application generates a unique tracking number and stores the request and associated item information in SharePoint. The system then sends a structured notification to the designated Microsoft Teams channel, with an optional email notification where required. The stored information remains available for future retrieval and updates, while SharePoint data can also be exported to Excel for reporting, record-keeping, and analysis. Create Supply Request → Enter Employee & Job Site Details → Add Supply Items → Upload Photos → Submit Request → Generate Tracking Number → Store in SharePoint → Send Teams/Email Notification → Retrieve, Update or Export Request Data
Project Summary
1. Application Overview The Employee Supply Request Power App is designed to provide employees with a structured digital process for submitting supply requests from their job sites. Through the application, employees can enter their details, add multiple requested items, upload supporting photos, and submit the complete request through a single process. Once submitted, the application generates a unique tracking number, stores the request information in SharePoint, and sends the request details through Microsoft Teams with an optional email notification. The stored request data can also be exported to Excel for record-keeping and analysis. 2. Supply Request Management Employees can create a new supply request by entering the required information, including: Employee Name Job Site Item Details The application allows multiple supply items to be added dynamically within the same request. Employees can review the added items as a list before submitting the request. When the request is submitted, the system automatically generates a unique tracking number that can be used to identify and track the submission. 3. Photo Upload The application allows employees to provide supporting photos as part of the supply request process. A photo upload prompt is presented during the request process for the required janitorial closet photo, and uploaded photos are linked with the relevant request. The request structure also supports a supply label photo against individual requested items. 4. Request Submission and Tracking Once all required information has been entered, the employee submits the request through the application. On submission, the system compiles the entered information and generates a unique tracking number for the request. This tracking number serves as the Request ID and links the main request with its associated supply items. This provides a structured method for maintaining both the overall request information and the individual items included within each request. 5. Microsoft Teams and Email Notifications Submitted requests can automatically be communicated to the designated team through Microsoft Teams . The application formats the request information into a structured Teams post so that the receiving team can easily review the submission. Users can also use an optional email notification, including notifications to multiple recipients where required. Notifications can include a summary of the request together with a link to the relevant submission. 6. Request Data Storage All submitted request information is stored in SharePoint . The main request stores information such as: • Request ID / Unique Tracking Number • Employee Name • Job Site Name / Number • Submission Date Individual requested items are maintained separately and linked back to the main request through the Request ID. Each item record can include: • Item Name / Description • Photo of Supply Label • Timestamp of Item Entry This structure allows the main supply request and all associated items to be retrieved and managed together. 7. Request Updates and Data Retrieval Stored requests can be updated when corrections are required or when additional items need to be added. This allows request information to remain maintainable after the initial submission rather than requiring a completely new request for every correction or addition. 8. Excel Export and Reporting Supply request information stored in SharePoint can be downloaded as an Excel file . This provides an accessible way to use submitted request information for record-keeping, reporting, and further analysis outside the application. 9. Testing and Validation The application includes functional testing of the individual modules as well as integration testing for Microsoft Teams and email notifications. Testing is intended to verify that the application features, request submission process, data storage, and notification functions operate correctly before final implementation. Overall Application Workflow The process begins when an employee opens the Power App and creates a new supply request. The employee enters their name and job site information, adds one or more required supply items, and provides the required supporting photos. Once the request is submitted, the application generates a unique tracking number and stores the request and associated item information in SharePoint. The system then sends a structured notification to the designated Microsoft Teams channel, with an optional email notification where required. The stored information remains available for future retrieval and updates, while SharePoint data can also be exported to Excel for reporting, record-keeping, and analysis. Create Supply Request → Enter Employee & Job Site Details → Add Supply Items → Upload Photos → Submit Request → Generate Tracking Number → Store in SharePoint → Send Teams/Email Notification → Retrieve, Update or Export Request Data
Location: Burlington, Massachusetts
Industry: Facilities Management / Commercial Cleaning / Janitorial & Building Maintenance Services
Challenge and Requirements
1.
Solution Delivered
CodeScale delivered a powerapps solution using PowerApps, PowerAutomate, SharePoint for Facilities Management / Commercial Cleaning / Janitorial & Building Maintenance Services.
Technology Used
- PowerApps
- PowerAutomate
- SharePoint
Business Outcome and Impact
1. Application Overview The Employee Supply Request Power App is designed to provide employees with a structured digital process for submitting supply requests from their job sites. Through the application, employees can enter their details, add multiple requested items, upload supporting photos, and submit the complete request through a single process. Once submitted, the application generates a unique tracking number, stores the request information in SharePoint, and sends the request details through Microsoft Teams with an optional email notification. The stored request data can also be exported to Excel for record-keeping and analysis. 2. Supply Request Management Employees can create a new supply request by entering the required information, including: Employee Name Job Site Item Details The application allows multiple supply items to be added dynamically within the same request. Employees can review the added items as a list before submitting the request. When the request is submitted, the system automatically generates a unique tracking number that can be used to identify and track the submission. 3. Photo Upload The application allows employees to provide supporting photos as part of the supply request process. A photo upload prompt is presented during the request process for the required janitorial closet photo, and uploaded photos are linked with the relevant request. The request structure also supports a supply label photo against individual requested items. 4. Request Submission and Tracking Once all required information has been entered, the employee submits the request through the application. On submission, the system compiles the entered information and generates a unique tracking number for the request. This tracking number serves as the Request ID and links the main request with its associated supply items. This provides a structured method for maintaining both the overall request information and the individual items included within each request. 5. Microsoft Teams and Email Notifications Submitted requests can automatically be communicated to the designated team through Microsoft Teams . The application formats the request information into a structured Teams post so that the receiving team can easily review the submission. Users can also use an optional email notification, including notifications to multiple recipients where required. Notifications can include a summary of the request together with a link to the relevant submission. 6. Request Data Storage All submitted request information is stored in SharePoint . The main request stores information such as: • Request ID / Unique Tracking Number • Employee Name • Job Site Name / Number • Submission Date Individual requested items are maintained separately and linked back to the main request through the Request ID. Each item record can include: • Item Name / Description • Photo of Supply Label • Timestamp of Item Entry This structure allows the main supply request and all associated items to be retrieved and managed together. 7. Request Updates and Data Retrieval Stored requests can be updated when corrections are required or when additional items need to be added. This allows request information to remain maintainable after the initial submission rather than requiring a completely new request for every correction or addition. 8. Excel Export and Reporting Supply request information stored in SharePoint can be downloaded as an Excel file . This provides an accessible way to use submitted request information for record-keeping, reporting, and further analysis outside the application. 9. Testing and Validation The application includes functional testing of the individual modules as well as integration testing for Microsoft Teams and email notifications. Testing is intended to verify that the application features, request submission process, data storage, and notification functions operate correctly before final implementation. Overall Application Workflow The process begins when an employee opens the Power App and creates a new supply request. The employee enters their name and job site information, adds one or more required supply items, and provides the required supporting photos. Once the request is submitted, the application generates a unique tracking number and stores the request and associated item information in SharePoint. The system then sends a structured notification to the designated Microsoft Teams channel, with an optional email notification where required. The stored information remains available for future retrieval and updates, while SharePoint data can also be exported to Excel for reporting, record-keeping, and analysis. Create Supply Request → Enter Employee & Job Site Details → Add Supply Items → Upload Photos → Submit Request → Generate Tracking Number → Store in SharePoint → Send Teams/Email Notification → Retrieve, Update or Export Request Data
Project Screenshots
