Project Summary
This Canvas app feature allows employees to complete vehicle inspection checklists from a mobile-friendly Power Apps interface. The app guides the user through selecting a vehicle, reviewing inspection items, marking each item as satisfactory, unsatisfactory, or not applicable, and submitting the completed inspection with notes and a signature.
Vehicle Selection and Checklist Loading
The user begins by selecting a vehicle from a filtered list of fixed assets. The combo box only displays assets where the equipment type is Vehicle, then formats the display value using the equipment number and fixed asset name. Once a vehicle is selected, the inspection checklist is populated for that vehicle.
SortByColumns(
AddColumns(
Filter(
'BC_Fixed Assets',
'Equipment Type' = "VEHICLE"
),
VehicleDisplay,
'Equipment Number' & " - " & 'Fixed Asset Name'
),
"VehicleDisplay",
SortOrder.Ascending
)
Guided Inspection Experience
The app prevents users from submitting incomplete inspections. Before a vehicle is selected, the checklist actions are unavailable. After the checklist loads, users can mark each row individually or use the Set All Satisfactory button as a shortcut, while still retaining the ability to change individual items if needed.
Submit Validation
The Submit button is only enabled when every checklist item has a selected status, the user has provided required notes for any unsatisfactory items, and the inspection has been signed. This ensures that submitted inspections are complete and actionable.
If(
(
CountRows(Filter(colChecklistRows, Status = "Unsatisfactory")) > 0
&& IsBlank(NotesTextInput.Text)
)
||
CountRows(Filter(colChecklistRows, IsBlank(Status))) > 0
||
!varMechanicSigned,
DisplayMode.Disabled,
DisplayMode.Edit
)
Unsatisfactory Item Handling
If any inspection items are marked unsatisfactory, the app displays those items on the notes screen and requires the user to explain the issue before submitting. This creates a cleaner handoff to maintenance because the problem is documented at the time of inspection.
Maintenance Follow-Up Automation
When an inspection includes unsatisfactory items, a Power Automate flow is triggered after submission. The flow creates a new work order listing the unsatisfactory items and sends a Teams notification to the maintenance technician so the issue can be reviewed and addressed.
Video Walkthrough
The video below demonstrates the full inspection process, including vehicle selection, checklist completion, unsatisfactory item notes, signature capture, and form submission.
Business Impact
This feature standardizes vehicle inspections, reduces incomplete submissions, improves maintenance visibility, and helps the company respond faster when a vehicle issue is reported. It also creates a better mobile experience for employees completing inspections in the field.
Skills Demonstrated
Canvas app design, Power Fx filtering, combo box configuration, collection-based checklist logic, conditional display modes, validation rules, signature capture, required notes logic, Power Automate integration, work order creation, and Teams notifications.