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!
