ENDEFRESNLTR
⚡ Automated 🏢 Energy, Utilities & Industrial Maintenance 👥 420 Field Technicians · 28,000+ Tracked Assets ⏱️ 5 Weeks (iOS / Android Mobile Canvas + Cloud Flows)

Convert Specific Files to PDF

Offline-capable mobile Power Apps solution enabling field engineers in zero-signal substations to scan QR/Code-128 asset labels, capture high-res inspection photos, strip EXIF/GPS metadata, compress images by 82%, and generate stamped PDF completion certificates.

-82%
Storage Footprint Saved
12 sec
PDF Report Turnaround
4,600 hrs
Annual Engineering Saved
100%
Offline Vault Reliability

⚠️ Legacy Challenge & Bottlenecks

Field crews inspected remote substations with paper checklists and WhatsApp photos, resulting in 10–14 MB smartphone JPEGs choking SharePoint storage quotas, missing asset serial numbers, unredacted GPS metadata in customer reports, and 5-day billing delays.

  • ✕Zero cellular connectivity inside underground utility vaults and remote wind sites
  • ✕Raw 12 MB mobile photos exhausting Dataverse/SharePoint file capacity
  • ✕Manual 45-minute Word report assembly per completed maintenance work order
  • ✕Customer sign-off disputes due to missing visual timestamps and seal stamps

✅ Power Platform + Zetaleap Solution

Built an offline-first Power Apps Canvas app utilizing local collections (`SaveData`/`LoadData`) and delegation-safe Dataverse sync queues. Equipment tags are generated via Zetaleap Vector QR/Code-128 API. Upon reconnect, Power Automate optimizes field photos to WebP with GDPR EXIF stripping (`UB-8`), merges photos into an inspection PDF (`UB-4`), applies a corporate approval stamp (`UB-5`), and archives heavy media into Zetaleap Drive Vault.

  • ✓Cut SharePoint & Dataverse image storage consumption by 82% via automated Zetaleap WebP optimization
  • ✓Instant customer PDF sign-off report delivered within 12 seconds of work-order completion
  • ✓Eliminated 4,600+ hours/year of back-office manual photo copy-pasting into Word reports
  • ✓99.8% asset identification accuracy using weather-resistant QR & Code-128B vector labels

⚡ 5-Stage End-to-End Execution Pipeline

01
Asset Tag Provisioning POST /api/pp/qr-barcode
Generates crisp vector QR & Code-128B SVG asset tags directly inside Power Apps print galleries.
02
Offline Substation Capture Power Apps Mobile (SaveData / LoadData)
Technician scans barcode, completes 35-point safety checklist, and captures 6–15 equipment photos offline.
03
Image Compression & EXIF Strip POST /api/studio/image-tools (UB-8)
Resizes 12 MB photos, strips sensitive GPS/device EXIF tags, and stamps inspection timestamp.
04
Stamped PDF Certificate Assembly POST /api/studio/html-to-pdf + /pdf-stamp (UB-5)
Renders multi-page A4 inspection report with photo grid and applies official QA engineering seal.
05
Vault Archival & Customer Dispatch Zetaleap Drive API + Outlook V2
Uploads archive to Zetaleap Drive and emails clean signed PDF + SLA KPI badge to facility manager.

🛡️ Enterprise Security, DLP & ALM Governance

  • ◆GDPR / KVKK compliant automatic EXIF GPS & device serial stripping before external customer delivery
  • ◆Zero delegation warnings across 28,000+ asset rows and 180,000+ historical inspection logs
  • ◆Per-user isolated Zetaleap Drive folder ACLs with expiring external share links
  • ◆Asynchronous HTTP 202 polling (`?async=true`) preventing timeouts on 20-photo PDF bundles

🧩 Technology & Connector Stack

Engineered with governed Microsoft Cloud services and drop-in Zetaleap Swagger 2.0 Custom Connectors:

Power Apps Offline MobileDataverse Mobile SyncZetaleap QR & Code-128 SVGZetaleap Image WebP & EXIF (UB-8)Zetaleap Images->PDF & Stamp (UB-4/5)Zetaleap Drive 30TB Vault
Swagger 2.0 Connectors Scope Similar Architecture →

🚀 Try the Live Zetaleap API Studios Featured in This Case Study

More Enterprise Case Studies

View All Case Studies (8) →