The challenge
Management reports were assembled by hand from spreadsheets and email. Nobody could tell who supplied which section, who approved it, or what changed between rounds.
Everything had to stay in the client's own SharePoint, run as the signed-in user with no elevated service, stay within SharePoint's 5,000-item list limits and remain portable to Dataverse. New reports, sections and fields had to be possible without a software release.
What we built
- Form DesignerDefine a report topic
- Versioned definitionStored in SharePoint
- Data entrySection by section
- Section approvalsEveryone submits once
- Excel workbookFor the completed period
Each report topic is a versioned definition stored in SharePoint, so adding a report, section or field is a data change. A Form Designer lets administrators design, preview, publish and staff a topic without editing configuration files.
Each approver reviews every section they hold and submits once. The topic moves on only when all have submitted, either to final approval or back to data entry with every comment attached. A completed period produces an Excel workbook and copies of its attachments.
Every save checks for conflicting edits, approvals are derived from the audit trail, and thirteen optional features stay off until a site owner turns them on.
Outcome
Packaged as the production release after two independent pre-production reviews, and covered by automated tests.
It ships with a re-runnable setup script, a deployment runbook with upgrade and rollback steps, and a user guide for each of five roles.