← All work 04 · The Master Group · Microsoft Power Platform

Company-wide QC data platform

A custom Microsoft Power Platform application — built in PowerApps, orchestrated by Power Automate, backed by SharePoint — that digitized quality control across the company. Field techs run 11-point and outbound inspections from their phones; flows automatically store, categorize, and clean the results. That clean, structured data is exactly what feeds the RTU QA vision model.

Role
Designed · built · trained · deployed
Stack
PowerApps · Power Automate · SharePoint
Reach
3 distribution centres
Feeds
RTU QA training data
0s
Avg entry time (was 1:40)
~0%
Faster than the old process
0+ hrs
Recovered per year
0
Distribution centres
🎯
Nobody asked me to build this

My title is quality control inspector, but I treated the role as a mandate to improve the process itself. The old Microsoft Forms flow took 1 minute 40 seconds per inspection. Knowing that 90%+ of units pass, I designed the app to pre-fill a passing result and let inspectors focus on triaging the exceptions — dropping average entry to 22 seconds, an ~80% cut that recovers 40+ hours a year across ~2,000 inspections. Deploying it meant writing the documentation, training the team at each centre, and earning adoption from three groups that each had their own way of working.

Interactive · demo

From a tech's phone to a training set.

Run through the flow the way the field does it: complete the PowerApps inspection on the left, submit, and watch Power Automate route the record — storing the photo, categorizing the QC result, cleaning the fields, and landing it all in SharePoint, ready to feed the model.

powerapps · 11-point inspection → power automate → sharepoint
QC INSPECTION APP
11-Point Inspection
Unit #RTU-4210
// Power Automate cloud flow

The cleaning step is where the value compounds: normalizing serials, de-duplicating captures, and tagging pass/fail is exactly what turns messy field photos into a labelable dataset — the bottleneck the RTU QA project lives or dies by.

How it fits together

One pipeline, low-code to deep-learning.

What each piece does

  • PowerApps — the field UI. Mobile-first inspection forms with photo capture, conditional logic, and offline-tolerant submission for 11-point and outbound QC.
  • Power Automate — the orchestration. On submit, flows file the photo, categorize the QC outcome, clean/normalize fields, and route records — no manual handling.
  • SharePoint — the backend. Structured lists + document libraries hold every inspection, serial-coded and queryable.
  • RTU QA — the payoff. A collection script pulls the failed-inspection photos straight out of SharePoint into the model's label pool.
Why it matters for AI

The unglamorous half of ML.

Most ML failures are data failures. This project shows I can meet an organization where it already lives — inside the Microsoft 365 stack — and build the durable, automated data plumbing that makes downstream AI possible. It's the same instinct that runs through every project here: the model is only as good as the pipeline feeding it.

See where the data lands: RTU QA →
The hardest question I aimed at my own job: why do we, as a distribution centre, inspect manually at all? We don’t control how the products are built — inspection is pure overhead. So the real goal isn’t a faster form; it’s to drive the cost of inspection toward zero and turn its data into evidence that holds manufacturers accountable. This app was step one: it quietly built the clean, labelled dataset that the RTU QA detection model now trains on to automate the inspection itself.
← All work