TLTan LeBackend & automation · CalgaryLet’s talk
← All posts

Power Automate business case: Slack alerts from Azure SQL

Posting alerts to Slack with Power Automate when a stored procedure in Azure SQL finds rows that hit the criteria.

From the archive · a 2021 working note, kept for reference.

Business case

Automatically post an alert message to Slack when data hits the criteria, using a stored procedure in Azure SQL.

Solution

Assume we already have the data below, produced by the stored procedure.

The flow:

The result in Slack:

First published on tanldt.blogspot.com on Aug 3, 2021.