At-Risk Deal Escalation Flow

Overview

A scheduled Power Automate Cloud Flow that runs every weekday morning to identify at-risk Salesforce opportunities, send each deal owner a coaching email with suggested next steps, post an escalation notice to a sales Teams channel for every flagged deal, and send the sales manager a daily summary email.

Use Case

Revenue leaders lose visibility into deals that are silently slipping — opportunities that blew past their close date or have been frozen in the same stage for weeks. By the time a sales rep realizes a deal needs intervention, the competitive window is often closed. This flow acts as a daily early-warning system that escalates at-risk opportunities before they are lost.

For every flagged deal, the owner receives a coaching email suggesting a decision-maker call within 48 hours, the sales manager channel gets a Teams post with full deal context, and the manager receives a consolidated daily summary email.

The flow is ideal for teams that:

• Opportunity is not closed (IsClosed = false)
• AND (CloseDate is in the past OR LastModifiedDate is older than the configurable stagnation threshold in days)

Flow Architecture

Environment Variables

Connectors & Connections

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Change the schedule

Edit the Run Daily At 8AM EST trigger. To switch to a weekday-only cadence, add a weekDays array such as ["Monday","Tuesday","Wednesday","Thursday","Friday"] to the recurrence schedule. To run at a different hour, edit the hours array.

Adjust the stagnation window

Change the value of flowlibs_AtRiskStagnantDaysThreshold in the solution. No flow edits needed.

Target different Salesforce stages

Add AND StageName IN ('Negotiation','Proposal') to the SOQL in the Compose SOQL Query action to restrict escalation to specific stages.

Include amount filter

Append AND Amount >= 10000 to the SOQL to skip low-value deals from escalation noise.

Redirect coaching emails

Update flowlibs_SalesFallbackCoachEmail to change where deals with missing owner emails are routed. To always route through a sales-ops mailbox regardless of owner email, replace the coalesce(...) expression in Send Coaching Email To Owner with just @variables('varFallbackCoachEmail').

Move to a different Teams channel

Update flowlibs_TeamsGroupId and flowlibs_TeamsChannelId — no flow edits required.

Extend the summary email

Replace the summary body with an HTML table by piping the opportunity array through a Select + Create HTML Table pattern before the summary action.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

formatDateTime(addDays(utcNow(), mul(int(variables('varStagnantDaysThreshold')), -1)), 'yyyy-MM-ddTHH:mm:ssZ')

if(less(item()?['CloseDate'], formatDateTime(utcNow(), 'yyyy-MM-dd')), 'Past Close Date', 'Stage Stagnation')

coalesce(item()?['Owner']?['Email'], variables('varFallbackCoachEmail'))

coalesce(item()?['Owner']?['Name'], 'there')

length(outputs('Query_At_Risk_Opportunities')?['body/records'])

formatDateTime(utcNow(), 'dddd, MMMM d, yyyy')