Request Management System — Power Platform End-to-End
BCHPR Admin Team · serves all employees · 2024 – present · v4.0 (Feb 2026)
Production-grade Microsoft Power Platform solution running the full lifecycle of financial and operational requests at BCHPR — submission, document validation, executive approval, payment, issue tracking, and reporting — built on SharePoint Lists, Power Automate, Teams Approval Cards, and a Power BI semantic model.
Highlights
- 8 Power Automate workflows orchestrating request creation, modification, payment, justification, issue tracking, document approval, lifecycle transitions, and daily reporting.
- Teams Approval Cards for 1-click approve / reject of justification documents — no SharePoint opening required.
- Power BI semantic model: 16 tables, 22 relationships (10 active + 12 inactive role-playing), 55+ DAX measures across 10 display folders.
- Auto-generated request IDs as primary keys linking every related record (payments, justifications, issues, files).
- Role-Based Access Control; automatic PartiallyPaid / FullyPaid / Overpaid status derivation; 30-day SLA tracking.
- Daily 3:50 PM Teams summary over Admin-Week (Thursday–Wednesday) windows; WTD / MTD / YTD / AWTD / TAW time intelligence.
Related projects
Designer & Lead Engineer
QR-Code Patient & Specimen Tracking System
Operational innovation deployed across 365+ primary health facilities and 25+ GeneXpert laboratories — now under active consideration by Cameroon's National TB Programme as national best practice.
Architect
Inventory & Asset Management — Manager.io + M365
Manager.io-integrated inventory and asset-management system for CHPR logistics across multiple Cameroon sites — with Microsoft 365 ecosystem orchestration (Lists, Power Automate, Power BI) and automated procurement workflows.
Lead BI Developer
Power BI Dashboards — 1,953 DAX measures across 8 models
Production Power BI estate with 8 major semantic models totalling 147 tables and 1,953 DAX measures — underpinning clinical decision-making, operational tracking, and executive reporting across every BCHPR research programme and the Admin Team Request Management System.