How to get email address of Azure member group in Power Automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I have an Group on Azure Active Directory which currently has 2 members of the group. The Group name is Test.

Further I have one SQL table which has several columns, one of the column called Group and contain Test as data.

Now I want through Power Automate send email to all the members of Test group on AAD. When the column Group is equal to Test.

So I want to make a condition I guess to make this works, but I really don`t know how to achieve this.

So as you can see here below. Currently the Flow pick up the email adres column. But I don`t want to use email adres anymore I want use the Column Group.

Thanks in Advance!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What kind of group is it? Not all groups have email addresses associated with them. In fact many don't.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

Is this what you mean? The group type is Security but it could also be Office.
If you click on this Group in Azure Active Directory then you can go to the members. So what I want is to send email to all the members of this Group.

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, that's what I mean. Azure AD security groups don't have an email address associated with them. So there is no way to send an email to the group. You would need to use a loop to get each member of the group and lookup their email to send an email to the members. Office 365 groups and Mail-enabled security groups are the only ones that have an email address.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

Thanks for your quick response! Do you have any example how to achieve this? Or could you explain me more in maybe in steps?

Thanks in advance!

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't have a ready made example, but here are the steps

1) Get the Azure AD groups that a particular user belongs to. You can filter for security groups only. (This is required to find the right group since you can't retrieve groups by name only by ID)

2) Loop through all the groups in #1 to find one that matches the name of the group you are looking for. Save the ID of that group to a variable.

3) Use that variable to get the members of the Azure AD group identified in #2 by using the ID you saved

4) Use a loop to either send emails or build a semicolon delimited string of email addresses using the output of #3. (One of the properties returned for each user is their SMTP mail address.)

5) If you built a string of addresses use that to address an email after you exit the loop. (it depends how many potential members are in the group whether you send the email in #4 or #5. #5 sends one email, but you can only have 256 TO: addresses in one email and there are limits how long a string you can have.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

I really need an example or something like that to try your manner. But for now I have another solution which is not dynamic but it works for now. As you can see each Procedure looks for one group. Further when the condition is True then I will put all the email addresses of the user from that Group. This will be done manually.

Was this reply helpful? Yes No