Send email to all members of a department, when status of SP list item changes

[d4v1d4bx]

Hi,

I'm trying to figure out how to get the department of the staff members. They are currently found in user profile of Azure AD and also can be found on the Delve profile. But I can't find a way how I get it.

Basically I build several automation, which they all work. But all the "To" on my Outlook 365 send email V2 actions are currently hardcoded.

I want to simple add the "To" field the department name, so Outlook automatically sends an email to all members of the department.

Thanks!

[Expiscornovus]

Hi @d4v1d4bx,

Just to double check. Can the members of a department only be found via the value of the department field or are to also members of one specific security or Office 365 group?

The second scenario would be a bit easier by using the Get Group members action.

If it is the first scenario I would say your best option would be to use the Graph API List users method with a filter and a select. Below is an example of that Graph API query:

https://graph.microsoft.com/v1.0/users?$select=mail&$filter=department eq 'IT'

 https://docs.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http

Let us know if you need any additional help setting this up?

[d4v1d4bx · Accepted solution]

Hi @Expiscornovus ,

I'm not sure if I understand you correctly with Office 365 group, but I assume you mean this.

Office365Users.MyProfile().Department

 With this code, I'm able to read and get the department name of my current user. I tried this with a text label in PowerApps and was able to display my department value.

What steps I need to do this in flow that, all members within a department get the emails? WIth just only adding the department name to the "To" in the send email step.

Thanks!

//Edit

I think and it looks like I can get this done with this method,

https://www.youtube.com/watch?v=MHO3o7kbV8k

[Expiscornovus]

Hi @d4v1d4bx,

Yes, a SharePoint Group would be an option. That video looks like a good approach.

An Office 365 Group could also be an option and you can just use the Get Group members action instead of the Send an HTTP request action. 

Another option could also be an Exchange dynamic distribution list group, with that one you even get a dedicated e-mail address which you can use:

https://docs.microsoft.com/en-us/exchange/recipients/dynamic-distribution-groups/dynamic-distributio...