topic Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline in Pipelines

How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

liney_marcela — Wed, 19 Mar 2025 21:58:08 GMT

Hello community,

I currently have a pipeline in Microsoft Fabric that sends email alerts based on a specific use case. To manage these alerts, I use a configuration table that contains the alert type and the email addresses associated with it.

So far, the process works through a stored procedure that queries this table and, depending on the alert frequency, sends an email to the configured recipients.

However, I now want to modify this logic to send alerts to a security group instead of individual email addresses. My idea is that email addresses would be associated with a security group, and by sending the alert to the group, all its members would automatically receive the notification.

My questions are:

- Is it possible to retrieve the email addresses associated with a security group within Microsoft Fabric?
- What would be the best way to integrate this functionality into my pipeline so that the stored procedure can handle security groups instead of fixed email lists?

I appreciate any guidance or recommendations on how to implement this efficiently.

Thanks in advance for your help!

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

lbendlin — Thu, 20 Mar 2025 00:23:00 GMT

so you need the equivalent of this ?

Get-ADGroupMember (ActiveDirectory) | Microsoft Learn

Do you have Graph API access?

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

NandanHegde — Thu, 20 Mar 2025 10:58:40 GMT

Are those security groups email enabled? Then you can use them directly to send email messgaes and no need to extract the members from them?
But in case if those are not email enabled, you can use REST APIs via Web activity
https://stackoverflow.com/questions/75221833/get-group-members-from-azure-ad-via-web-activity

ADF is similar to Data pipelines

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

Anonymous — Wed, 16 Apr 2025 12:29:19 GMT

Hi liney_marcela,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

spencer_sa — Mon, 21 Apr 2025 10:23:07 GMT

The 'security group' versus 'distribution list/group' debate that's raged since On-Prem AD days.
You might find this interesting - from 5 months ago.
https://www.reddit.com/r/microsoft365/comments/1gr08g1/entraid_dynamic_security_group_as_distribution/

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

Anonymous — Tue, 22 Apr 2025 11:39:24 GMT

Hi @liney_marcela,

May I ask if you have gotten this issue resolved?

Regards,
Vinay Pabbu

Re: How to Send Alerts to a Security Group Instead of Individual Emails in an MS Fabric Pipeline

Anonymous — Mon, 05 May 2025 12:27:22 GMT

Hi @liney_marcela,

May I ask if you have gotten this issue resolved?

Regards,
Vinay Pabbu