Image Preview
1 / 1
HomeCase StudiesIntegrated Management System
Integrated Management SystemISO 9001Quality ManagementDataversePower Automate1 min readApril 2026

Integrated Management System

A UK construction business was managing non-conformances and ISO 9001 compliance through spreadsheets and SharePoint folders. We built an Integrated Management System on Dataverse to centralise non-conformance tracking, corrective actions and evidence management in one governed platform, with live visibility, automated reminders and a clear timeline linking every action back to the issue it relates to.

RL
Rob Lees
Founder & Principal Consultant
SectorFacilities Management
Business Size100+
Technology
DataversePower Automate
Delivery Time8 weeks
The Challenge

Non-conformance tracking running across spreadsheets and SharePoint folders

The client’s Integrated Management System was spread across Excel and SharePoint. Non-conformance records were created, updated and circulated in spreadsheets, with evidence files dropped into SharePoint folders named by ID number. Every review involved switching between systems to piece the story together, which took time and made it harder to keep records aligned and current.

Beyond the records, there was no structured way to assign corrective and preventative actions, track completion or see the status of outstanding issues at a glance. Managers had no single live view across the business, audit trails were spread across multiple tools, and without automated reminders, items stayed open longer than the quality team wanted. Internal and external audits took noticeably longer to prepare for because the supporting picture had to be assembled by hand each time.

The client wanted a single Integrated Management System that brought non-conformances, tasks, evidence and audit trails into one place, with consistent workflows and reporting designed around ISO 9001 from the start.

  • 📊

    Spreadsheet-based tracking

    Non-conformances tracked in Excel with no live visibility and constant manual upkeep across multiple workbooks.

  • 📂

    Fragmented evidence storage

    Evidence files stored in SharePoint folders by ID number, requiring constant switching between systems.

  • ⚠️

    No task assignment workflow

    No structured way to assign corrective actions or track completion, leading to overdue items and chase-up by email.

  • 🔍

    Limited visibility and audit trails

    Managers had no real-time view of outstanding issues, and audit trails were spread across multiple tools.

Key Outcomes
Non-ConformancesCentralised
Task VisibilityReal-time
Evidence StorageIntegrated
Audit TrailComplete
PDF ReportsAuto
Time to Go-Live8 weeks
Technology Used
Model-Driven AppDataversePower AutomateSharePointPDF Generation
The Solution

An Integrated Management System on Dataverse with automated workflows

We designed and built an Integrated Management System as a model-driven app on Microsoft Dataverse. The platform brings non-conformance tracking, task assignment and evidence management into a single governed system. Users create non-conformances, assign corrective and preventative actions, attach evidence and track completion in one place. Automated workflows handle reminders and escalations, and managers get live visibility of outstanding issues. The build sits behind the same patterns we use across our wider Power Platform consultancy work for construction and facilities management.

  • 01

    Non-conformance management in a model-driven app

    Quality teams create non-conformance records directly in the Integrated Management System, capturing source (audit, client complaint, internal review), description, severity and affected area. The form drives the full lifecycle from creation through investigation to closure, with a complete audit trail of every change against the record.

    Model-Driven AppDataverseAudit TrailWorkflow Tracking
  • 02

    Task assignment and corrective actions

    Within each non-conformance, users create tasks for corrective and preventative actions, assigning them to specific people with due dates and priorities. Assignees are notified automatically and update status in the app rather than over email. Managers see every outstanding task across the business and can drill into completion rates by area, owner or severity.

    Task ManagementAssignmentsNotificationsDue Dates
  • 03

    Evidence management in one place

    Evidence is uploaded directly within the Integrated Management System and stored against the record. Photos, documents and reports attach straight to non-conformances and tasks, so everything related to an issue lives in one place under the same governance and access controls. No more switching to SharePoint to find the file referenced in the spreadsheet.

    Document StorageFile AttachmentsCentralised EvidenceAccess Control
  • 04

    Automated PDF reports and an objective tracker

    When a non-conformance is closed, the platform generates a PDF summary showing the full story: who raised it, every assigned task, the corrective actions taken, who completed each one and when, and the evidence behind each step. The same Integrated Management System includes an Objective Tracker module for managing business objectives with the same workflow: create the objective, assign tasks, attach evidence, track progress and produce a PDF summary on completion.

    PDF GenerationObjective TrackingAutomated ReportsPower Automate
Delivery

Eight weeks from discovery to go-live

A structured programme with clear milestones, fortnightly client demos and no surprises at go-live. The Integrated Management System was deployed through a governed pipeline across Dev, Test and Production environments, following Microsoft Power Platform ALM guidance, with the ISO 9001 audit trail validated end-to-end.

01
Weeks 1–2
Discovery & ISO Requirements Analysis
Workshops with quality managers, auditors and operational teams. ISO 9001 non-conformance requirements mapped. Dataverse schema designed for non-conformances, tasks and evidence.
02
Weeks 3–5
Model-Driven App Build & Data Migration
Model-driven app built with non-conformance forms, task assignment and evidence upload. Historical non-conformance data migrated from spreadsheets. Security roles configured for each user type.
03
Weeks 6–7
Automation & PDF Generation
Power Automate workflows built for notifications, reminders and escalations. PDF generation configured for closed non-conformances. Objective Tracker module added with the same workflow patterns.
04
Week 8
UAT, Training & Go-Live
User acceptance testing with the quality team and operational managers. ISO 9001 audit trail validation. Training delivered. Production deployment and go-live support.

ISO 9001 by Design

The Integrated Management System was built with ISO 9001 requirements embedded from day one. Every non-conformance carries a full audit trail showing who raised it, the actions assigned, who completed each task and when, and the supporting evidence behind every step. PDF summaries give auditors the full picture without anyone assembling it by hand.

Integrated Features

  • Non-conformance tracking
  • Corrective action management
  • Task assignment workflows
  • Evidence storage and retrieval
  • Objective tracking module
  • Automated PDF reporting
The Results

One Integrated Management System, full control of quality

100%

Centralised Tracking

Every non-conformance, task and piece of evidence managed in one Integrated Management System. No more spreadsheets or fragmented folders.

Real-time

Task Visibility

Managers see every outstanding corrective action across the business, with live status and completion tracking.

Auto

Reminders & Escalation

Automated notifications keep tasks moving. Overdue actions escalate to managers without anyone chasing them.

Complete

Audit Trail

Full history of every non-conformance: who raised it, every action taken, who completed each task and when.

Integrated

Evidence Storage

Supporting evidence stored within the app. No more switching between systems or searching SharePoint folders.

PDF

Automated Reports

Comprehensive PDF summaries generated automatically when non-conformances close, ready for ISO 9001 audits.

Your project

Got a manual process you want to replace?

Book a free 30-minute discovery call. We will map your current process, show you what the Power Platform can do for your business and give you a clear view of what is achievable, with no commitment required.

Free 30-min discovery call No obligation Response within 1 business day