Skip to content

Branch Audit Questionnaire App for 180 Branches

Building products distributor, UK and Europe

In short

How can head office track site audits across hundreds of branches?

The client collected branch audit feedback from 180 branches on a Word template: 180 files to send, chase, read and file, and no single view of what was done. We built a Power Apps audit app where each branch answers, attaches evidence and submits, and head office sees the status of every audit.

Results in numbers

branches off Word templates
180

At a glance

  • 180 branches moved off Word templates
  • Seven audit sections with photos and PDF
  • SharePoint and Microsoft 365 only

The client

The client distributes specialist building products through branches and distribution centres across the UK and Europe. The audit covers the physical condition of each site, from access and gates to structure and installed services.

What it was costing them

  • Time: each branch filled in a Word template by hand, and every returned file had to be opened and filed.
  • No single source of truth: answers sat in separate documents, so comparing branches meant copying data.
  • No visibility: head office could not see which of the 180 audits were open and which were returned.
  • Weak evidence: photos of gates, roofs and loading areas had no standard home next to the answers.

What we built

We built a Power Apps canvas app on SharePoint, with Power Automate handling permissions, notifications and PDF output.

  • One place for every audit: each questionnaire is stored in SharePoint, with files in a folder per audit.
  • Faster completion: tabs for general info, access and parking, external fabric, structure and internal fabric, service installations, comments and attachments, with a 1 to 5 rating and comment per question.
  • Evidence on the spot: users attach up to six photos or files at a time.
  • No lost work: an audit can be saved as a draft or submitted back to the requester.
  • The right people see the right audit: a Power Automate flow sets permissions per questionnaire.
  • Nobody chases by email: notifications go out when an audit is ready and when it is returned.
  • A record for the file: a Print to PDF button produces a PDF of the questionnaire.
  • Live status: the home screen lists every audit with site, date, branch manager, completed by and status.
  • Safe rollout: a dedicated environment, laptop and tablet layout, and a two-round acceptance test.

Results

  • Audit process for 180 branches moved from a Word template to one app with one data store.
  • Seven audit sections per questionnaire, each question rated 1 to 5 with a comment.
  • Four Power Automate flows in scope: permissions, ready notification, returned notification and PDF generation.
  • After the first demo the client asked for small changes and the flows, started using the app on 17 July 2023, and discussed a second phase.

The risk most teams miss

Simple SharePoint apps fail quietly. By month three, lists hold many answers per audit across 180 branches and repeat rounds, which pushes against view limits and slows screens. The first scope also used one environment for build, test and go-live. We kept the app to two screens, grouped answers by questionnaire and files by folder, and used a service account as owner. Separate environments should come before a second phase.

What we would add today

Improvements we would add on top of what is live.

  • Move answers to Dataverse with row-level security by region, so area managers see only their branches.
  • Add a Power BI or Fabric report comparing scores by branch, region and question.
  • Create a corrective action for every low score, with an owner, due date and Power Automate reminder.
  • Use AI Builder prompts to group free-text comments into themes.
  • Separate development, test and production with Power Platform pipelines, and run flows under a service principal.

Technology

Power Apps canvas app, SharePoint Online lists and libraries, Power Automate, Outlook notifications, Microsoft Entra ID security group, Microsoft 365.

Tell us how many sites you audit and what you collect today, and we will tell you how quickly an app can replace the paper and Word files.

Products and capabilities

  • Power Apps
  • Power Automate
  • SharePoint
  • canvas app
  • audit app
  • PDF generation
  • inspection checklist

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.