Microsoft Fabric Updates Blog

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	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline

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
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
							
						
					
			
		
	
			
	
	
	
	
	
 
  2.  In your pipeline, click on Copy Data
    copy data in your workspace
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
  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
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
							
						
					
			
		
	
			
	
	
	
	
	
 

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
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
    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 
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
    I chose to send a message to a teams channel called “test teams channel”.
    thumbnail image 7 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
    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
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
							
						
					
			
		
	
			
	
	
	
	
	
 

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
	
	
	 
	
	
	
				
		
			
				
						
							Notifying Outlook and Teams channel/group from a Microsoft Fabric pipeline
  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 

Related blog posts

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

February 22, 2024 by Miquella de Boer

We are very excited to announce a lot of new improvements to data destinations in dataflows gen 2. Here is an overview of the new improvements and how to get started. After you have cleaned and prepared your data with dataflows gen 2, you want to land your data into a destination. This is possible … Continue reading “Dataflows gen 2 data destinations and managed settings”

February 21, 2024 by Sean Mirabile

Sean Mirabile | Sr. Program Manager | Microsoft Fabric CAT Special thanks to all of the technical reviewers: Kevin Lee, Bret Myers, Sundar Easwaran, and Mallikarjun Appani Content Introduction Blog 1: ADLS Gen2 Event Triggers (on create) Data Pipeline Settings The Get Metadata Activity YouTube Video Complete Data Pipeline JSON Introduction Welcome to the blog … Continue reading “Fabric Data Pipelines – Advanced Scheduling Techniques (Part 1)”