Send reminders and escalate overdue approval requests using scheduled cloud flows and Dataverse dates.
Implementation approach
Create a scheduled flow that queries only Pending requests whose Due Date is earlier than the current time and whose Escalation Level is below the maximum. Send a reminder to the current approver and update Last Reminder Sent. After the configured threshold, assign the request to an escalation owner or notify a supervisor. Use a stable request ID to prevent duplicate reminders. Respect business calendars and time-zone behavior; compare normalized timestamps and test daylight-saving boundaries if users operate across regions.
Recommended validation
- Build the flow inside a solution and use connection references.
- Test with real Dataverse security roles and least-privilege connections.
- Handle retries, duplicate triggers, timeouts, and connector failures.
- Keep business status and audit data in Dataverse.
- Verify the complete process in a non-production environment before deployment.
