How to setup MS Teams notifications based on the error log from Azure SQL Database table?

Ron Zhong — Tue, 27 Aug 2024 06:39:21 +0000

To create a Power Automate flow that sends a Microsoft Teams message whenever a new row is inserted into an Azure SQL Database table, you can follow these steps:

Select the Power Automate template from Azure SQL Database instance.

You may login Azure SQL Database with Microsoft Entra ID

Add a trigger “When an item is created (V2)” for detecting new rows from particular data table

To apply Filter Query for only monitoring the data rows having value DATA_PUSH_FAILED
status eq 'DATA_PUSH_FAILED'

Add an action “Get an @mention token for a user” for getting a MS Teams user reference for the step 3

Add the 2nd action “Post message in a chat or channel“ for sending message to MS Teams group chat

After saving the workflow, we can test it.

Either through Manually adding new rows or Automatically use the last tests is fine.

Here we have already inserted some rows for testing.

Here is the outcome!!

p.s. Perhaps we could further learn from the team and on beautifying the template to make it more inspiring to protect the team from Alert Fatigue.

DEV Community: Ron Zhong

How to setup MS Teams notifications based on the error log from Azure SQL Database table?