Overview

Sifflet integration for Microsoft Teams allows you to receive notifications in case of data quality issues on your most critical tables.

Set up the Integration and Configure Channels

To set up the integration, go through the following steps:

1. You first need to create a workflow for your channel(s) in Teams. Microsoft's official guidelines on how to do so are available here.
   1. Go to your Microsoft Teams application
   2. On the left side of Teams, click the Teams entry to view your teams and channels.
   3. Right-click the name of the channel you want to send notifications to on the left sidebar. Alternatively, click the channel of interest and hit the three-dots button on the top right-hand corner of the application.
   4. Click the Workflows entry of the dropdown menu.
   5. Type "webhook" in the search bar and click on the Post to a channel when a webhook request is received Templates result.
   6. Give your workflow a name such as "Sifflet Data Quality Alerts"
   7. Ensure that you are signed in to Microsoft Teams.
   8. Click Next.
   9. Select the Teams team and the Teams channel where you would like the workflow to run.
   10. Click Add workflow to add the workflow to the channel.
   11. Copy the URL displayed on the following screen. You will need to input in your Sifflet application.
2. Go to your Sifflet application to configure an alert destination with the freshly created URL.
   1. Hover the Setting entry of the sidebar and click the Collaboration Tools entry.
   2. Scroll down to find the Microsoft Teams integration card.
   3. If not done already, click the toggle button to enable the Microsoft Teams integration.
   4. Add the name of your Teams channel in the Name field.
   5. Copy paste the freshly created URL in the Webhook URL field.
   6. Click Save.
3. You can now use this webhook in Sifflet monitors to receive notifications on your Teams channel when a data quality issue is detected.

Configure Private Channels

Because Power Automate workflows don't support yet flow bots posting messages to "Private" Teams channels (flow bot is the default posting method used by the Post to a channel when a webhook request is received template when creating a workflow), a workaround is to slightly tweak your workflow to allow Sifflet to post messages to private channels.

To do so, go through the following steps:

1. Go to the Worflows section of your Teams application
2. Click on the name of the flow you created for Sifflet
3. Click the Edit button at the top of the page
4. Click the Send each adaptive card tile
5. Click the Post card in a chat or channel
6. Change the value of the Post as parameter from Flow bot to User
7. Click Save
8. You should now be able to use this webhook in Sifflet monitors to receive notifications on your Teams private channel when a data quality issue is detected.

Use Channels in Monitors

Once you have configured your Microsoft Teams channels, you can start using them in your monitors to receive notifications in case of data quality issues.

To do so, go through the following steps:

1. Go to the Monitors page and click + New Monitor to create a new monitor or click the Edit button on the details page of one of your existing monitors.
2. In the Overview and notifications section, Notification method subsection, if not done already, click the toggle button to notify by Microsoft Teams.
3. Click the dropdown and select the channel(s) of interest in the list.
4. Click Update or Save.

Note that you can add one or several channels to multiple monitors in one go by leveraging the bulk edit capabilities that are available on the Monitors page once you select monitors.