Sorentis
Back to all work
Enterprise Case Study

Regional Local Government — Breakdown

Empowering regional municipal operations: custom Power Apps canvas tools, multi-stage Power Automate workflow engines, and a complete organisation-wide SharePoint intranet built with decentralised departmental ownership — all delivered within standard base M365 licensing.

Microsoft 365 Digital Workplace & Process Architecture
Base M365 E3 Standard$0 Incremental Licensing
Canvas Applications

Capital Works Inspections

Mobile field audit application for daily site checks, multiple inspection templates, and central filing.

Community Asset Register

Public equipment loan register tracking borrower details and dynamic availability in real-time.

HQ Visitor Attendance

Reception kiosk sign-in with photo capture and instant staff host arrival alerts.

Power Automate Flows
Multi-Stage Approval RoutingAutomated delegation & sign-off across municipal hierarchy.
Automated Overdue TriggersScheduled background flows notifying borrowers of due dates.
Instant Outlook & Teams AlertsReal-time adaptive cards sent directly to operational staff.
Standard M365 Connectors100% Native
SharePoint Digital Workplace

Decentralised Staff Intranet

Enterprise-wide intranet built from scratch, empowering 20+ individual teams to manage their own departmental hubs.

Relational Data Architecture

Structured SharePoint Lists acting as high-performance relational tables for assets, logs, and inspections.

Systems Implementation

Proven integration with Zeller EFTPOS, PerfectGym, CMS migration, and Freshservice ITSM.

The Architecture: High-Value Solutions on Base M365 E3 Licensing

Organisations often assume enterprise digital transformation requires costly specialised SaaS subscriptions or expensive Power Platform premium licensing tiers. For this Victorian regional local government authority, we engineered a suite of robust, production-grade business applications entirely within the client's existing Microsoft 365 E3 standard footprint. By pairing Power Apps canvas applications with multi-tier Power Automate flows and secure SharePoint Online relational lists, we delivered zero-incremental-cost solutions that remain fully managed and supported internally.

Enterprise Staff Intranet: Organisation-Wide SharePoint Migration

Led the end-to-end design, architecture, and deployment of a brand new enterprise Staff Intranet upon migrating the organisation to SharePoint Online. Delivered largely as a dedicated solo initiative, the platform was structured around a decentralised ownership model: individual teams across People & Culture, Finance, Business Improvement, Community Services, and Infrastructure gained the autonomy to curate, update, and govern their own departmental sites and document repositories. This eliminated administrative bottlenecks and established seamless cross-departmental communication for nearly 1,000 staff across distributed civic facilities.

Field Operations & Operational Applications

Designed, built, and supported multiple targeted operational applications that replaced manual paperwork and disconnected spreadsheets: (1) Capital Works Inspections: A field-ready mobile application allowing civil inspectors to execute daily on-site evaluations, choose across multiple inspection protocols, trigger automated email digests to project managers, and archive records in centralised storage; (2) Community Asset & Loan Register: A self-service kiosk and register solution connecting Power Apps to dual relational SharePoint tables via Power Automate to track community equipment borrowing, log customer details, and execute scheduled automated background flows for return reminders; (3) Headquarters Visitor Attendance & Security: A reception kiosk application capturing visitor sign-ins, photo recording, and automated instant notifications dispatched to host staff via Outlook and Microsoft Teams.

Systems Implementation, Integration & Procurement Governance

Beyond custom Microsoft applications, our delivery spanned critical enterprise system rollouts across municipal operations: rolling out modern contactless EFTPOS payment terminal infrastructure (Zeller) from the ground up for regional performing arts and event centres; implementing enterprise leisure and facility management software (PerfectGym) across regional recreation and aquatic centres; and supporting the technical business analysis and delivery for the municipal public website CMS migration alongside vendor development partners. Furthermore, we authored standard Functional Specification and Evaluation Scoring templates that continue to govern institutional procurements, and administered Freshservice ITSM workspaces and automated incident resolution workflows.

Zero-Incremental-Cost M365 Architecture

Bespoke enterprise applications engineered entirely within standard base M365 E3 licensing using Power Apps, Power Automate, and SharePoint Lists — avoiding expensive premium connector fees.

Decentralised Enterprise Intranet

Organisation-wide SharePoint intranet designed and built from scratch, empowering departmental teams with self-service site governance to connect nearly 1,000 staff.

Mobile Field & Capital Inspections

Field-ready inspection applications enabling on-site compliance checks, multi-type audit logging, and automated email alerts directly into centralised repositories.

Automated Asset & Visitor Registers

End-to-end register solutions synchronising dual SharePoint tables via Power Automate, with automated due-date reminders, photo capture, and real-time host notifications.

Enterprise Systems & Payment Rollouts

Ground-up deployment of modern EFTPOS payment terminal fleets, enterprise leisure management platforms (PerfectGym), and municipal website CMS migrations.

Procurement Governance & ITSM Workspaces

Standardised institutional Functional Specifications, quantitative tender scoring matrices, and automated Freshservice ITSM service catalog workflows.

Technologies & Platforms Used

Microsoft Power Apps
Power Automate
SharePoint Online
Microsoft Lists
Microsoft 365 (E3)
Microsoft Teams
Outlook Automation
Zeller EFTPOS
PerfectGym
Freshservice ITSM
Business Process Analysis
Enterprise Solutions

Ready to Automate Your Business?

Learn how Sorentis can streamline your workflows, eliminate manual administrative friction, and connect your Microsoft ecosystem.

Book a Technical Consultation