Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

sallydabbah
Microsoft Employee
‎09-20-2023 08:25 AM

Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline

Introduction

Setting up alerts for pipeline failures on a Teams channel/outlook mail enhances communication, collaboration, and problem-solving within your team. It creates a streamlined workflow for addressing issues, reduces downtime, and promotes a culture of continuous improvement in managing your data pipelines.

In this blog, I'll showcase a method for sending notifications to both Teams channels/groups and Outlook emails. Microsoft Fabric now includes Teams activity as a recent addition.

simple architecture of sending notifications in fabric</p> <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>

Prerequisites

  1. Basic knowledge of Data Factory pipelines.
  2. Workspace in Microsoft Fabric. 
  3. Teams channel & outlook account (you can do only one of them).

Steps

  1.   Create Pipeline in Fabric Data Factory, click on create pipeline. 
    add new pipeline to fabric workspace <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p> 

  2.  In your pipeline, click on Copy Data
    copy data in your workspace <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>

  3. create a basic copy activity - Fill all the details and make sure that it will fail this is the use case that we want to be notified on. 
    PS: connect to the teams and the outlook activities on fail in the copy activity like so: 
    pipeline activities <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p> 

Steps for adding Teams Activity

  1. Add Teams activity by navigating to the Activities tab and dragging the Teams activity onto the canvas. Then, within the Settings tab, log in to your Teams account.
    teams connection <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>
    You should get loading screen (it will create a team's connection) and after it fill the relevant information, in my case:
    thumbnail image 6 of blog post titled</p> <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>
    I chose to send a message to a teams channel called "test teams channel".
    thumbnail image 7 of blog post titled</p> <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>
    In message tab, i attached the output of the copy activity.@concat('Copy Activity Failed, Details:',activity('Copy data').output)details of settings in Teams activity:

  2. Output for Teams activity:
    output of teams activity <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p> 

Steps for adding Outlook activity

  1. In activities tab, drag outlook activity
  2. Connect our copy activity on fail to the outlook activity
  3. Same as in teams' activity, in settings tab sign into your outlook account
  4. Fill relevant information about the failure, in advanced tab, i choose to be sensitivity to be confidential @concat('Copy activity in Notification pipeline failed, details:',activity('Copy data').output)
  5. Output for the Outlook activity:
    output of outlook activity <p>Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline</p> <p>

  6. You can see in the output that it was classified as important and confidential as I listed in the activity settings.

Resources

Module 3 - Automate and send notifications with Data Factory - Microsoft Fabric | Microsoft Learn 
How to copy data using copy activity - Microsoft Fabric | Microsoft Learn 

Labels:
0