Product Discontinuation Alert Workflow

Overview

CF-246 - Product Discontinuation Alert Workflow is a Beginner-level scheduled cloud flow that monitors Salesforce for products marked as inactive or discontinued, then alerts the sales team via Microsoft Teams and sends email notifications to affected account owners. It runs daily at 8:00 AM UTC to catch any products deactivated in the previous cycle.

Use Case

When a product is discontinued in Salesforce, sales representatives with open opportunities tied to that product need immediate notification. This flow automates that alert chain by querying Salesforce for inactive products, building an HTML summary table, posting a consolidated alert to a Teams channel, sending a high-importance email to the sales alert distribution list, and sending a normal-priority digest copy to a separate recipient.

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 Recurrence trigger to adjust frequency or time zone.

Modify the Salesforce filter

Update the OData filter in 'Get Discontinued Products' to target different criteria (e.g., filter by ProductFamily, add date range with LastModifiedDate).

Customize the email template

Edit the 'Compose Alert Email Body' action to change HTML styling or add/remove columns from the product table.

Add more recipients

Update the environment variable values or add additional Send Email actions.

Enable the flow

Toggle the flow to On after configuring environment variable values for your environment.

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.

@greater(length(body('Get_Discontinued_Products')?['value']), 0)

body('Get_Discontinued_Products')?['value']

concat(variables('varAlertHtml'), '<tr><td>', items('For_Each_Discontinued_Product')?['Name'], '</td><td>', items('For_Each_Discontinued_Product')?['ProductCode'], '</td><td>', items('For_Each_Discontinued_Product')?['Family'], '</td><td>', items('For_Each_Discontinued_Product')?['LastModifiedDate'], '</td></tr>')

add(variables('varDiscontinuedCount'), 1)