Executive Summary
A large municipal utility needed a more reliable way to manage field inspections, corrective actions, deadlines, and customer-facing letters across a complex environmental compliance program. Inspectors were already using Microsoft Dynamics 365 Field Service, Dataverse, and Resco Mobile, but the business rules behind corrective actions had grown difficult to verify: different inspection types followed different closeout paths, mobile questionnaire logic depended on script conventions, and report templates had to stay synchronized with questionnaire behavior.
H1AI helped turn that complexity into a governed mobile inspection platform. The team reconstructed the as-is inspection processes, mapped them against Resco and Dataverse artifacts, isolated fragile automation seams, and delivered targeted patches for stormwater corrective-action workflows, mobile report outputs, reminder automation, and inspection-status visibility.
Customer Profile
The customer is a large public-sector utility responsible for municipal inspection and environmental compliance programs. Its field teams inspect businesses, private stormwater facilities, and spill or complaint cases. The organization operates in a regulated environment where accurate documentation, deadline tracking, and accountable communications matter for both operational follow-through and public trust.
Business Challenge
The utility’s inspectors needed a mobile-first process that worked in real field conditions while still enforcing the program’s regulatory logic. Corrective actions were not just checklist answers; they became rows in Dataverse, deadlines, follow-up work, customer letters, and closure decisions.
Several challenges had accumulated:
- Corrective-action behavior differed by inspection type: standard business inspections, fixed-in-the-field corrections, audit visits, private stormwater inspections, and spill/complaint workflows.
- Mobile questionnaires generated structured records and report language through JavaScript and naming conventions, making small configuration changes risky.
- Follow-up rules, completion dates, extension deadlines, and report wording needed to match the intended business process.
- Report links and mobile report templates had to survive Resco/Woodford revise and publish cycles.
- Stakeholders needed clearer documentation to support city IT review, change governance, and future testing.
Solution Delivered
H1AI approached the work as both a business-process discovery effort and a technical modernization sprint.
First, H1AI documented the inspection process in operational terms: how corrective-action rows are created, when each row receives a compliance date, when the corrective-action envelope closes, and how each inspection path differs. This produced a shared model for five core flows: business inspection, fixed-in-the-field correction, audit, spill/complaint, and private stormwater facility inspection.
Next, H1AI mapped those flows to the actual platform implementation. The team reviewed Resco questionnaire exports, Woodford artifacts, JavaScript, mobile report XML, Power Automate solution packages, logs, status files, and change records. That artifact review identified where business behavior lived: questionnaire rules, mobile scripts, Dataverse tables, report bindings, work-order closeout rules, and cloud flows.
Finally, H1AI delivered concrete improvements. Examples included refining private stormwater corrective-action comment behavior, correcting mobile report wording and date formatting, preserving and documenting report relink requirements, packaging a Dataverse/Power Automate reminder-flow fix so overdue corrective actions continue to trigger daily reminders, and adding status/visibility improvements for inspection management.
Technology Stack
- Microsoft Dynamics 365 Field Service, with work orders used as inspections
- Microsoft Dataverse corrective-action and site/account records
- Resco Mobile CRM and Woodford configuration
- Resco Questionnaire Designer / QBuilder exports
- JavaScript mobile questionnaire logic
- Resco mobile report XML templates
- Microsoft Power Automate cloud flows
- Structured H1AI documentation, changelogs, and implementation notes
Results & Benefits
Because the source package is an internal project record rather than a closed-out public case study, exact performance metrics are not available. The documented benefits are therefore qualitative and evidence-based:
- Clearer governance over a complex mobile inspection platform
- Reduced ambiguity around corrective-action lifecycle rules
- Safer Resco/Woodford change cycles through documented relink and verification checklists
- More accurate customer-facing corrective-action letters
- Stronger deadline follow-up through a packaged reminder-flow update
- Better alignment between business process, mobile UI behavior, structured Dataverse records, and report outputs
H1AI Perspective
This engagement shows H1AI’s value in the difficult middle layer between business process, field operations, and low-code enterprise platforms. The work was not simply “make a form change.” It required understanding inspection policy, mobile offline behavior, Dataverse record lifecycles, report rendering, Power Automate packaging, and the operational realities of municipal field teams.
H1AI’s advantage was the ability to investigate across all of those layers, produce traceable documentation, and ship practical changes without losing sight of the business process the platform was meant to enforce.
Future Opportunities
The same foundation can support broader modernization: consolidated spill reports, stronger signature governance, automated recipient selection for corrective-action letters, expanded map and quadrant views for field planning, and regression tests around year-boundary completion dates and report relinks.