Automating Patient Form Follow-Ups for a Mental Health Provider
OfficePro Consulting built a follow-up automation layer for a mental health provider on top of its Microsoft Fabric data warehouse. Scheduled flows check daily for patients with outstanding forms, send personalised reminders, escalate the ones that go unanswered and close off automatically once a form is returned.
Discuss your automation project →The challenge: chasing outstanding forms by hand
Every new patient is sent intake forms and further forms go out at set points across a course of treatment. Completion mattered, but keeping track of who had and had not responded was a manual job that pulled clinical staff away from care.
What we built
Two scheduled Power Automate cloud flows that run against the provider's Microsoft Fabric data warehouse and drive the whole follow-up cycle without staff intervention.
How it works
Each run pulls the current list of outstanding forms from Fabric. For each patient the flow checks where things stand and takes the right step: send a first reminder, send a follow-up where one is due, escalate to a nominated staff member once a patient has been reminded a set number of times, or close the record once the form is returned. Reminders are branded emails sent from a central shared mailbox, each linking the patient straight to the correct form. The behaviour is controlled through configuration rather than code, so the provider can adjust timing, escalation and content without changing the flow.
Delivery phases
Technologies
Project snapshot
Related services
The results: an automated follow-up loop, live in production
What changed once the flows went live, from manual chasing to a loop that runs itself.
More client stories
More from our recent work.
Ready to automate your follow-ups?

