Scene 1 (0s)
[Audio] SOW & DELIVERABLE TRACKING SYSTEM React + ASP.NET Core Architecture & Flow How the frontend, API layer, and Power Automate integrations work together to move a SOW from upload to signed, tracked, and paid.
Scene 2 (18s)
[Audio] Why React + ASP.NET Core for this app Power Automate handles the system-to-system glue. This layer is where people actually work. Document review UX Relational tracker data AI-extracted SOW fields sit next to the source PDF for an approver to confirm or correct — needs custom interaction, not a form builder. Scope, Deliverables, and Budget trackers span multiple SOWs, CRs, and one PO — a real schema handles this better than canvas-app data tables. Full control over Zycus calls Complements Power BI / Automate PR, PO, and GR payloads are shaped exactly to Zycus's API rather than squeezed through a generic HTTP connector. You keep growing your Power Platform skills on orchestration and reporting, while the app layer plays to your strongest stack. SOW & Deliverable Tracking System — React + ASP.NET Core Architecture.
Scene 3 (1m 21s)
[Audio] High-level architecture Power Automate Zycus PR/PO/GR · Docusign React SPA ASP.NET Core Web API SQL Server Trackers, review screens, approval queue Validation, business rules, auth Scope · Deliverables · Budget · SOW/CR history Power BI (embedded) Entra ID (SSO) Budget & status reporting Role-based access per approver ASP.NET Core exposes a REST API — React never calls Zycus, Docusign, or Power BI directly.
Scene 4 (2m 4s)
[Audio] Core screens & trackers Each tracker view rolls up to its own detail screen Dashboard Scope tracker Budget tracker Deliverables Milestones Reports SOW review & extraction Approval queue Invoice & GR matching Signed SOW alongside AI-extracted deliverables, owners, dates, and cost — approver confirms before it writes to the tracker. Invoice line items checked against completed deliverables (fixed-cost) or against monthly caps (T&M) before GR post. Role-scoped view per approver (IT PO, BTO, Procurement, Legal) showing only what's pending their sign-off..
Scene 5 (2m 45s)
[Audio] Flow 1 — SOW to signed tracker entry Every step after upload runs through the ASP.NET Core API; React never talks to Power Automate or the database directly. Vendor SOW uploaded AI extraction Approver review ASP.NET Core API validates Trackers updated Into React upload screen Power Automate calls extraction, returns fields to API React screen: source PDF next to extracted fields Applies business rules, writes record Scope, Deliverables, Budget in SQL Server.
Scene 6 (3m 25s)
[Audio] Flow 2 — Invoice to budget update Fixed-cost invoices are matched against a completed deliverable; time & material invoices are matched against a monthly cap. Invoice submitted Match check GR posted Approval & payment Budget tracker updated Vendor invoice in Zycus ASP.NET Core API checks deliverable or T&M cap Power Automate posts GR in Zycus Zycus approval chain releases funds Consumed vs. remaining refreshed.
Scene 7 (4m 2s)
[Audio] Flow 3 — Change request A CR reuses Flow 1's approval chain, not the invoice chain, and adds funds to the original PO — no new PO is created. Vendor submits CR Same approval chain New PR created Funds added to PO Trackers updated Against the original signed SOW IT PO → BTO → Procurement → Legal, rerun Power Automate, sized to CR cost Original PO — never a new one New rows tagged to the original SOW.
Scene 8 (4m 37s)
[Audio] Tech stack Layer Technology Frontend React + TypeScript, component library for tables & forms Backend ASP.NET Core Web API (C#) Database SQL Server — relational schema across SOW, CR, PO, trackers Auth Entra ID SSO, role-based access per approval stage Integration Power Automate — Zycus (PR/PO/GR), Docusign, notifications Reporting Power BI, embedded in the React app for PM/leadership views Hosting Azure App Service (API) + Azure Static Web Apps (frontend).
Scene 9 (5m 23s)
[Audio] Suggested next steps Define the data model SOW, CR, PO, and the three trackers — get the relationships right first. Build the review-screen MVP The AI-extraction confirmation screen is the highest-value, hardest-to-buy-off-the-shelf piece. Wire Power Automate connectors Zycus PR/PO/GR calls and Docusign webhooks, called from the ASP.NET Core API. Pilot with one PM on one program Validate the tracker workflow end-to-end before rolling out broadly..