Robert Plant

Automation Architect — Power Automate | Power Apps
Theme

Designing automation that removes friction and restores focus

I build Power Automate flows and Power Apps that remove manual steps, reduce errors, and free teams to do meaningful work. Scroll to see the story behind each project: the situation, task, action, and the measurable results.

Tip: this page follows your device color preference and remembers your choice.

Collatz Runtime Insight

Dynamically sourced from the Prime Collatz tracker.

Highest Value Reached
Loading…
Most Efficient Prime
Loading…
Snapshot
Loading…
Full run history lives in the Collatz tracker repository.
Initializing live statistics…

COVID19, Power Query and Access: A Transformational Automation Project

Situation

During the COVID-19 lockdown, a duty clerk was tasked with manually consolidating seven daily reports for 550 personnel. This consumed 4–5 hours per day, straining operational capacity and delaying decision-making.

Task

Design and deploy an automated solution to consolidate these reports into a single, actionable view of unit health — with minimal training overhead and full auditability.

Action

Architected a Power Query–driven data model inside Microsoft Access to automate the consolidation logic. Delivered a Business Process Guide and provided remote onboarding support. Engaged stakeholders to overcome initial scepticism and validate the model’s output.

Result

Reduced daily processing time from 245 minutes to 7 minutes — a 97% reduction. Reclaimed over 1,300 hours of manual effort across the lockdown period. Delivered zero-touch logic with symbolic audit clarity, enabling resilient reporting under pressure.

Tech
Power Query + Access

Built a modular, traceable data model with ceremonial formatting and stakeholder-ready outputs.

Zero-touch logic
Audit clarity
Business Process Guide
Impact
1,300+ hours saved

Enabled consistent reporting with minimal support. Demonstrated resilience, polish, and architectural clarity.

97% time saved
Lockdown resilience
Operational tempo

Daily Occurrence Register: Digitising Paper Processes with MS Forms and SharePoint

Situation

The Daily Occurrence Register was a critical paper-based record maintained manually by duty clerks, leading to inefficiencies, delays, and risks of data loss or inaccessibility during incidents.

Task

To digitise the existing paper process using available Microsoft 365 tools to improve accessibility, accuracy, and auditability while reducing administrative overhead.

Action

Designed and implemented a Microsoft Forms front-end for data entry linked to a SharePoint List backend with role-based access controls. Ensured replication of all legacy fields, enforced security permissions, and linked entries to user accounts for accountability.

Result

Achieved a secure, accessible, and audit-ready digital register that reduced paper handling costs, improved data accuracy and timeliness, enhanced audit trails, and enabled real-time reporting, demonstrating effective digital transformation using existing infrastructure.

Tech
Microsoft Forms + SharePoint Online

Digitised a paper-based process into a sustainable new way of working.

Agile Project Management
Audit clarity
Business Process Guide
Impact
100% uptake

Enabling data consistency, secure data storage, auditability, with user-friendly submissions.

Agile project management
Timestamped entries tied to entraObjectID
Microsoft Forms interface replicates the paper form fields for ease of use.

Password Dictionary Storage Requirements: Visualising the Scale of Exhaustive Search

Situation

Password guidance often tells learners to use longer passwords without showing why exhaustive candidate dictionaries quickly become impractical to store.

Task

Create an accessible classroom visualisation that compares dictionary storage growth across common character-set rules and familiar storage-capacity benchmarks.

Action

Built a responsive Chart.js model covering password lengths from 8 to 32 characters. Used logarithmic calculations to represent exhaustive dictionaries for 52, 62, and 76-character sets without relying on imprecise large-number exponentiation.

Result

Delivered a portable teaching page that makes exponential storage growth visible against home NAS, datacentre, and global-storage assumptions. The chart is optimised for projection, interaction, and PowerPoint screenshots.

Tech
Chart.js + logarithmic modelling

A standalone browser visualisation with no build step and clear, inspectable calculations.

Responsive chart
Accessible line styles
Scientific tooltips
Impact
Exponential scale made visible

Connects password-length advice to realistic storage constraints before cracking time is considered.

Classroom ready
Screenshot friendly
Passphrase context

Tree of Lights: A Shareable Charity Dedication Experience

Situation

CWBI 2020 Virtual Lions Club wanted to explore a festive, non-religious online experience where visitors could remember someone special and optionally support the charity.

Task

Turn an early concept into a material stakeholder demonstration covering the public tree, dedication submission, sharing journey, moderation workflow, and separate JustGiving handoff.

Action

Designed and built a responsive proof of concept with an interactive bauble tree, accessible list view, dedication preview, browser-based moderation queue, focused sharing links, and HTTPS deployment through Plesk.

Result

Delivered a working end-to-end demonstration that stakeholders can explore on desktop or mobile before committing to production hosting, shared persistence, authentication, and operational governance.

Experience
Interactive Tree of Lights

A polished visitor journey that makes dedications tangible while keeping charitable donations optional and clearly separate.

Responsive design
Accessible list view
Focused sharing URLs
Prototype
Submission to publication

Demonstrates the full dedication lifecycle using fictional data and local browser storage.

Moderation preview
HTTPS deployed
Stakeholder ready

How I work

Modular flows, defensive guards, symbolic audit blocks, clear decision gates, and measurable KPIs at every step. I build artefacts that are traceable and easy to maintain.

Approach highlights: modular design, audit logging, stakeholder validation

Ready to collaborate

If you'd like a walkthrough of any project, an architecture diagram, or a proof-of-concept flow, get in touch and I’ll share downloadable artefacts and runbooks.

Alternatively, reach out via LinkedIn