🏗️ Enterprise Production System · SharePoint & Dataverse

Facilities Audit &
Compliance Engine

Replaced multi-day manual audit cycles with mobile inspection forms, JSON-parsed checklist scoring, automated PDF reports, and a real-time Power BI compliance dashboard.

60%
Faster Audit Cycles
100%
Digital Data Entry
0
Missed Deadlines
The Problem

Multi-Day Audit Cycles, Manual Everything

Monthly facility compliance audits required inspectors to complete detailed checklists across multiple facilities, compile inspection data into formatted PDF reports, route them through management review, and archive approved reports by deadline. The entire process was manual, taking multiple staff-days per cycle and regularly running close to regulatory deadlines.

A New Leaf — Facilities Management Division  ·  Timeline: 2023–2024  ·  Impact: 60% reduction in audit cycle time
The Solution

Mobile Forms, JSON Parsing, Automated Reporting

A normalized Lists & Forms architecture captures inspection data once, computes compliance scores automatically, and generates audit-ready PDF reports without manual compilation.

Lists & Forms Architecture
  • Facility Registry List — master list of all facilities with address, responsible manager, inspection frequency, and compliance category.
  • Inspection Checklist Items List — normalized checklist items organized by category and facility type, used to build dynamic forms.
  • Inspection Records List — custom Power Apps form providing a structured, mobile-friendly section-by-section inspection experience.
  • Deficiencies Tracking List — each deficiency with severity, responsible party, corrective action, and resolution deadline.
  • Microsoft Forms Integration — for field inspectors without Power Apps access, parsed automatically into Inspection Records via Power Automate.
Automation Architecture
  • Power Automate parsed complex nested JSON payload from Microsoft Forms, mapping fields to Inspection Records List columns.
  • JSON parsing extracted array-structure checklist scores, computed section totals and overall compliance percentage.
  • Dynamic PDF generation rendered a formatted compliance report populated with inspection data, deficiency details, and photo evidence.
  • Power BI report connected to Inspection Records List provided a real-time compliance dashboard for the Facilities Director.
⬡ Also Designed & Formally Presented As
Dataverse Relational Architecture ✓ Presented
This solution was formally re-presented with a complete Microsoft Dataverse data model — showing how the Microsoft Forms + JSON parsing pipeline maps to structured Dataverse entities with weighted scoring Business Rules and Power BI DirectQuery for true real-time dashboards.
mka_facility
Core entity. Type, ComplianceCategory OptionSets.
mka_inspectionrecord
1:N ← facility. OverallScore (Decimal), Status OptionSet.
mka_checklistitem
Reusable library of 80+ items. Weight, IsFailureCritical.
mka_inspectionresponse
Junction: inspection × checklist item. Drives weighted score.
mka_deficiency
1:N ← inspection + facility. Severity, corrective action.
⚡ Business Rule: Calculates weighted average score from all responses — replaces the JSON parsing flow with server-side calculation.
📊 Power BI DirectQuery on Dataverse — true real-time dashboard, aggregations pushed down to the query engine.

Explore the Interactive Showcase

Live Lists-style mockup with a toggle to view the parallel Dataverse schema

View Interactive Showcase →
Measurable Results

Faster Cycles, Zero Missed Deadlines

60% reduction in end-to-end facility audit and approval cycle time
100% elimination of manual data re-entry from paper forms to digital records
Zero missed monthly regulatory compliance deadlines post-deployment
Complete photographic evidence archive linked to every inspection record
Microsoft Lists Microsoft Forms Power Apps Power Automate JSON Parsing PDF Generation SharePoint Online Power BI ⬡ Dataverse Model-Driven App C# Plugin