Create Escalation and Reminder Flows for Pending Dataverse Approvals: Series 8

Create Escalation and Reminder Flows for Pending Dataverse Approvals: Series 8

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.