2025 · INTERNAL TOOLS | WORKFLOW AUTOMATION
PO Automation Platform
Replaced a paper-based purchase order process at a K-12 school — 200+ monthly transactions, dual-approval routing, and automatic PDF generation.
Built at Immaculata-La Salle High School
Tech Stack
Overview
The school ran purchase orders through paper forms, routed them manually, and filed PDFs by hand. I replaced that with a SharePoint backend, a Power Automate pipeline that routes approvals by department and dollar threshold, and a dashboard where staff can track every request. PDFs generate automatically when an order is approved. The fiscal year resets on July 1 — no manual rollover required.
What I Built
- Dual-approval workflow routing by department and amount threshold
- Automated PDF generation and email notifications via Power Automate
- Fiscal year rollover — resets automatically on July 1 each year
- MSAL authentication — only authorized staff can access the dashboard
- SharePoint REST API for attachment handling and list management
- SPA dashboard showing PO status, history, and filters
- Custom domain deployment at po.ilsroyals.com
What I Learned
Rotating exposed Power Automate SAS URLs and migrating to OAuth bearer token authentication after security audit
SharePoint REST API pagination and attachment handling at scale
Fiscal year state management without a traditional database
Building multi-stakeholder approval flows where each approver has different data visibility