How to Send Opportunity Stage Alerts to Slack with Power Automate

My flows > + New flow > Automated cloud flow

Create automated cloud flow

Navigate to make.powerautomate.com and click 'My flows' in the left sidebar. Click the '+ New flow' button at the top of the page. Select 'Automated cloud flow' from the dropdown menu. Name your flow 'Opportunity Stage Alerts' and leave the trigger selection for the next step.

1. 1Click 'My flows' in the left navigation
2. 2Click the '+ New flow' button
3. 3Select 'Automated cloud flow'
4. 4Enter 'Opportunity Stage Alerts' as the flow name
5. 5Click 'Create' without selecting a trigger

Flow designer > Choose trigger > Salesforce

Add Salesforce trigger

In the trigger search box, type 'Salesforce' and select the Salesforce connector. Choose 'When a record is created, updated or deleted' as your trigger. This gives you the most control over which field changes fire the automation. You'll configure the specific conditions in the next step.

1. 1Type 'Salesforce' in the search box
2. 2Click on the Salesforce connector
3. 3Select 'When a record is created, updated or deleted'
4. 4Click 'Create' to add the trigger

Salesforce trigger > Connection settings

Configure Salesforce connection

If this is your first Salesforce connection, click 'Sign in' and authenticate with your Salesforce credentials. Choose your Salesforce environment (Production or Sandbox). Set Object Name to 'Opportunity' from the dropdown. Leave the Condition field blank for now - you'll filter for stage changes using a condition step later.

1. 1Click 'Sign in' to authenticate with Salesforce
2. 2Select your environment (Production/Sandbox)
3. 3Choose 'Opportunity' from Object Name dropdown
4. 4Leave Condition field empty
5. 5Click outside the step to save

Flow designer > + New step > Condition

Add stage change condition

Click '+ New step' below the trigger. Search for and select the 'Condition' control. You need to filter for only stage changes, not every opportunity update. In the left side of the condition, select 'StageName' from the Salesforce dynamic content. Set the operator to 'is not equal to' and leave the right side empty for now.

1. 1Click '+ New step' below the Salesforce trigger
2. 2Search for 'Condition' in the actions list
3. 3Select the Condition control
4. 4Click in the left condition box
5. 5Select 'StageName' from dynamic content

Condition Yes branch > + Add an action > Salesforce > Get record by Id

Get opportunity owner details

In the 'Yes' branch of the condition (when stage changed), add a new action. Search for 'Salesforce' and select 'Get record by Id'. Set Object Type to 'User' and Record Id to the 'OwnerId' field from the opportunity trigger. This lookup gets the owner's name and email for the Slack message.

1. 1Click '+ Add an action' in the Yes branch
2. 2Search for and select Salesforce connector
3. 3Choose 'Get record by Id' action
4. 4Set Object Type to 'User'
5. 5Set Record Id to 'OwnerId' from dynamic content

Get record > + Add an action > Slack > Get user by email

Find Slack user by email

Add another action and search for 'Slack'. Select 'Get user by email' to match the Salesforce owner with their Slack account. If you haven't connected Slack yet, you'll need to authenticate. Set the Email field to the Email from the User record you just retrieved. This ensures DMs go to the right person.

1. 1Click '+ Add an action' below Get record
2. 2Search for 'Slack' and select the connector
3. 3Choose 'Get user by email' action
4. 4Authenticate with Slack if prompted
5. 5Set Email to the Email field from the User record

Get user > + Add an action > Slack > Post message

Send Slack DM

Add a final Slack action and select 'Post message'. Set Channel to the User ID from the previous step (this creates a DM). Compose your message using dynamic content from the opportunity. Include the opportunity name, new stage, amount, probability percentage, and expected close date for a complete notification.

1. 1Click '+ Add an action' below Get user by email
2. 2Select Slack connector again
3. 3Choose 'Post message' action
4. 4Set Channel to the User ID from Get user step
5. 5Compose message with opportunity details

Flow designer > Save > Test in Salesforce

Test the flow

Click 'Save' in the top right to save your flow. Go to your Salesforce org and change an opportunity's stage to trigger the automation. The flow should fire within 30 seconds and send a DM to the opportunity owner. Check the flow run history in Power Automate to see if it succeeded or failed.

1. 1Click 'Save' in the top toolbar
2. 2Navigate to your Salesforce org
3. 3Open any opportunity record
4. 4Change the Stage field to a different value
5. 5Save the opportunity record

Add this expression in the Slack message text box to format currency properly and handle null amounts gracefully.

if(empty(triggerOutputs()?['body/Amount']), 
  'Amount not set', 
  concat('$', formatNumber(triggerOutputs()?['body/Amount'], '0,0'))

if(empty(triggerOutputs()?['body/Amount']), 
  'Amount not set', 
  concat('$', formatNumber(triggerOutputs()?['body/Amount'], '0,0'))
)

concat(
  '🎯 Deal Update: ', triggerOutputs()?['body/Name'], 
  ' moved to ', triggerOutputs()?['body/StageName'], '\n',
  '💰 Value: ', if(empty(triggerOutputs()?['body/Amount']), 'Not set', concat('$', formatNumber(triggerOutputs()?['body/Amount'], '0,0'))),
  ' (', triggerOutputs()?['body/Probability'], '% probability)\n',
  '📅 Expected close: ', formatDateTime(triggerOutputs()?['body/CloseDate'], 'MMM dd, yyyy'), '\n',
  '🏢 Account: ', body('Get_record')?['Account']?['Name']
)