Streamlining your tech stack for maximum efficiency

Learn, explore, and grow with our knowledge hub.

Build a Site Inspection App in Power Apps | Smart Statistics
Power Apps Practical Tutorial

Build a Site Inspection App in Power Apps: Replace Paper Checklists with Structured Data

Paper inspection forms are easy to start with but difficult to manage at scale. Handwriting must be interpreted, photographs sit in separate folders, corrective actions are followed up by email and management reporting often requires another spreadsheet.

A Power Apps inspection application can bring those activities into one structured process: inspectors complete the checklist on a phone or tablet, capture evidence, record issues and save the inspection directly to a governed data source.

Digital checklists Standardise the inspection process.
Evidence capture Keep supporting evidence with the record.
Action tracking Turn failed checks into follow-up work.
Structured reporting Analyse inspection records without rekeying.
Site Inspection

General Information

Site
Birmingham Office
Inspector
Alex Johnson
Date
20/08/2026

Inspection Checklist

Fire exits clear
Yes No N/A
Emergency lighting
No Yes N/A
First aid kit complete
Yes No N/A

Evidence

📷 3 supporting photographs attached

Corrective Action

Replace emergency light
Due: 27/08/2026
Open
Inspection Compliance 92%

Illustrative dashboard metric showing completed compliant checks.

Structured Data

Each inspection becomes a searchable record rather than another document or email attachment.

Why Digitise Inspections?

Move from Completed Forms to Usable Business Data

The real value of digitising an inspection is not simply replacing paper with a screen. It is creating structured information that can support follow-up, reporting, accountability and continuous improvement.

Standardise the Checklist

Give every inspector the same questions, response options and mandatory fields.

  • Consistent inspection structure
  • Required questions
  • Clear response options

Keep Evidence Together

Supporting photographs and documents can remain associated with the inspection record.

  • Evidence with the inspection
  • Less searching through folders
  • Better audit context

Track Corrective Actions

Failed checks can trigger defined follow-up rather than disappearing into comments or email chains.

  • Action owner
  • Target completion date
  • Status tracking

Report from the Data

Structured records can feed operational reporting without somebody manually retyping inspection results.

  • Inspection trends
  • Open-action reporting
  • Site and category analysis
Solution Architecture

Start with a Simple Three-Part Pattern

For a straightforward departmental inspection process, Power Apps can provide the user experience while SharePoint stores the structured records and Power BI or Excel provides downstream analysis.

Power Apps

Mobile-friendly interface for completing inspections and reviewing records.

SharePoint Lists

Structured inspection and action records with Microsoft 365 permissions.

Reporting

Use Power BI or Excel to analyse compliance, trends, locations and outstanding actions.

Step 1

Design the SharePoint Inspection List

Avoid starting in Power Apps before deciding what data the business actually needs. A good app normally starts with a clear data structure.

Column Suggested Type Purpose
Title Single line of text Human-readable inspection reference.
Site Choice or Lookup Location being inspected.
InspectionDate Date Date the inspection took place.
Inspector Person User responsible for the inspection.
FireExitsClear Choice Example response: Yes, No or N/A.
EmergencyLighting Choice Structured checklist response.
FirstAidComplete Choice Structured checklist response.
Comments Multiple lines of text Inspector notes and observations.
OverallStatus Choice Example: Compliant, Attention Required, Critical.
Attachments SharePoint attachments Supporting photographs or documents.
Design note: these fields are an example only. Your production list should reflect the actual inspection questions, governance requirements and reporting needs of your organisation.
Step-by-Step Build

Build the Inspection App from Start to Finish

The formulas below use an edit form called frmInspection connected to a SharePoint list called Site Inspections.

01

Create the canvas app

Create a canvas application in Power Apps and connect it to the SharePoint list containing your inspection records.

  • Create the app in the correct Power Platform environment.
  • Add the SharePoint data connection.
  • Select the site and the Site Inspections list.
  • Use responsive containers where practical.
Build the application in the environment where it will be governed and supported. Avoid treating the creator's personal workspace as the permanent production architecture.
02

Add a browse screen

Give inspectors a simple landing screen showing recent inspections and a button for starting a new one.

New Inspection Button — OnSelect
NewForm(frmInspection);
Navigate(
    scrInspection,
    ScreenTransition.Fade
)

NewForm() changes the form into new-record mode before the user reaches the inspection screen.

03

Configure the inspection form

Add an Edit Form control named frmInspection and set its data source to the SharePoint list.

Form — DataSource
'Site Inspections'
Form — Item
galInspections.Selected

Add the required SharePoint fields to the form and arrange them into logical sections such as general information, checklist, comments and evidence.

04

Default the inspector and date

Where appropriate, reduce unnecessary data entry by defaulting information that Power Apps already knows.

For a date picker used for a new inspection, a common default is:

Today()

For a SharePoint Person field, retain the generated Combo Box structure unless you have a specific reason to customise it. Person fields require a record rather than plain text.

Do not store the inspector only as free text if the business needs Microsoft 365 identity, filtering or accountability. A Person field is normally more useful for that requirement.
05

Add structured checklist responses

Avoid putting important inspection answers into one large comments field. Use structured response fields that can later be filtered and reported.

For example, a SharePoint Choice column might contain:

Yes
No
N/A

This allows the organisation to answer questions such as:

  • Which sites have failed fire-exit checks?
  • How many inspections contained a failed item?
  • Which checklist categories fail most often?
06

Add evidence attachments

Add the SharePoint Attachments field to frmInspection. This allows inspectors to attach supporting files to the inspection record.

Keep the Attachments control inside the form. With SharePoint, adding and deleting attachments is tied to the form save process.

This approach can be useful for photographs of defects, supporting documentation or other inspection evidence.

07

Validate before submission

The app should make incomplete inspections difficult to submit.

If the required properties on the form are configured correctly, the form's Valid property provides a useful validation check.

Save Button — OnSelect
If(
    frmInspection.Valid,
    SubmitForm(frmInspection),
    Notify(
        "Please complete all required inspection fields.",
        NotificationType.Warning
    )
)

This uses the form's built-in validation before calling SubmitForm().

08

Handle successful submissions

Rather than placing navigation immediately after SubmitForm(), use the form's OnSuccess property. That ensures the success behaviour occurs after Power Apps has successfully saved the record.

frmInspection — OnSuccess
Notify(
    "Inspection saved successfully.",
    NotificationType.Success
);

Navigate(
    scrHome,
    ScreenTransition.Fade
)
frmInspection — OnFailure
Notify(
    "The inspection could not be saved. " &
    frmInspection.Error,
    NotificationType.Error
)
Separating save, success and failure behaviour makes the app easier to understand and gives the inspector clearer feedback.
09

Add edit and cancel behaviour

Existing inspections can use the same form in edit mode.

Edit Button — OnSelect
EditForm(frmInspection);

Navigate(
    scrInspection,
    ScreenTransition.Fade
)
Cancel Button — OnSelect
ResetForm(frmInspection);

Navigate(
    scrHome,
    ScreenTransition.Fade
)

ResetForm() discards unsaved changes in the form before returning the user to the previous screen.

10

Create corrective actions

For a more scalable solution, create a second SharePoint list called Inspection Actions.

Suggested fields include:

  • Inspection ID
  • Action description
  • Action owner
  • Target date
  • Status
  • Completion notes

Separating actions from inspections allows one inspection to have several corrective actions without adding repeated action columns to the inspection list.

11

Filter the inspection gallery carefully

As the list grows, pay attention to Power Apps delegation. Not every Power Fx operation can be delegated to every data source.

A straightforward example for filtering by site might look like:

Filter(
    'Site Inspections',
    Site.Value = cmbSiteFilter.Selected.Value
)
Always check Power Apps for delegation warnings against your actual SharePoint column types and formula. A formula that appears correct against a small test list may return incomplete results when a non-delegable operation is used against a larger source.
12

Test before publishing

Test the application as a business process, not simply as a collection of controls.

  • Create a new inspection.
  • Save an inspection containing attachments.
  • Edit an existing inspection.
  • Test required-field validation.
  • Test with a standard user account.
  • Confirm SharePoint permissions.
  • Test the app on the intended phone or tablet.
  • Confirm reports receive the expected data.
Ask at least one genuine end user to test the inspection process. The person building the app already knows how it is supposed to work and may miss usability problems that are obvious to a first-time inspector.
Optional Next Step

Add Workflow with Power Automate

Once the inspection data is structured, Power Automate can handle follow-up tasks that previously depended on somebody remembering to send an email.

Failure Notifications

Notify the relevant manager when an inspection contains a critical or failed check.

Action Reminders

Remind action owners when corrective work approaches or passes its target date.

Management Summaries

Distribute scheduled summaries of open actions, recent failures or overdue inspections.

Escalation

Route unresolved high-priority actions to another level of management after a defined period.

Production Governance

Build an App the Business Can Actually Support

A successful inspection app needs more than attractive screens. Ownership, permissions, change control and data quality should be designed alongside the application.

Named Ownership

Define who owns the application, the inspection process and the underlying SharePoint data.

Permissions

Review app sharing and data-source permissions so users receive only the access they require.

Change Control

Document changes to checklist questions, formulas, SharePoint columns and workflow logic.

Monitoring

Review usage, failed processes, data quality and outstanding actions after deployment.

Illustrative Business Impact

Measure More than Paper Saved

The figures below are illustrative examples only. Actual outcomes depend on the inspection volume, existing process and solution design.

1

Structured Process

One defined digital workflow for completing inspections.

Illustrative Rekeying

Design objective: remove manual transcription from paper into a reporting spreadsheet.

100%

Illustrative Traceability

Design objective: each submitted inspection has a structured digital record.

1+

Reporting Options

Structured data can support Power BI, Excel and operational views.

Illustrative figures only: these are examples of potential design outcomes, not guaranteed performance claims. Establish a baseline before implementation and measure the actual result afterwards.
Frequently Asked Questions

Power Apps Inspection FAQs

Can Power Apps replace paper inspection forms?
Yes. Power Apps can provide structured digital forms for inspections, audits, checks and other operational data-capture processes. The right architecture depends on the complexity, scale and governance requirements of the process.
Can inspectors attach photographs?
Yes. When SharePoint is used as the data source, its attachments field can be added to a Power Apps form. The attachments control should remain within the form because adding and deleting attachments is committed through the form save process.
Can the app work on a phone?
Yes. Canvas apps can be designed for mobile use. Test the interface on the actual devices inspectors will use rather than relying only on the desktop authoring preview.
Should I use SharePoint or Dataverse?
SharePoint can work well for many straightforward Microsoft 365 departmental applications. Dataverse may be more appropriate where the solution requires richer relationships, security, application lifecycle management or more complex enterprise architecture.
Can inspection data be reported in Power BI?
Yes. Once inspection information is captured as structured records, it can be used for reporting on areas such as compliance, failures, locations, categories and outstanding actions.
Can Power Automate send reminders?
Yes. A separate Power Automate workflow can monitor inspection or action records and send reminders, notifications or escalations according to your business rules.
What are delegation warnings?
Power Apps attempts to delegate supported query operations to the underlying data source. When an operation cannot be delegated, Power Apps may only process a limited set of records locally. Delegation warnings should therefore be reviewed carefully when designing applications for growing datasets.
How can Smart Statistics help?
Smart Statistics can design and improve Power Apps, Power Automate workflows, SharePoint data structures, Power BI reporting and wider Microsoft Power Platform solutions for UK businesses.

Still Running Important Inspections on Paper, Email or Spreadsheets?

Smart Statistics helps UK businesses turn manual operational processes into practical, governed Microsoft Power Platform solutions.

From Power Apps data capture and Power Automate workflows to Power BI reporting and process improvement, we can help you design a solution that is useful for employees and manageable for the business.