How to send email only to selected members of SharePoint group?

Like (0) Share

Report

Posted on 26 Jul 2021 13:32:18 by jsarlii

Hey guys,

I am struggling with my flow which is sending email notification only to selected members of SharePoint group. The problem is that all available tutorials are showing how to send email to all members.

Example of users in SharePoint group:

User 1 - Job Title: Accountant

User 2 - Job Title: Manager

User 3 - Job Title: Director

User 4 - Job Title: Accountant

I want to send the email only to Managers and Director(s). Is it doable to check the job title and send to email only to specific users?

Thank you for any help!

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

eliotcole 4,280 Moderator on 26 Jul 2021 at 16:54:15

Like (0)

Report

Re: How to send email only to selected members of SharePoint group?

I like it ... but ... heh ... it also relies on the SharePoint Groups matching the 365 groups ... which could not be a thing, too (if my experience is anything to go by 😅).

@jason_c_wyatt wrote:
Hi,

A low code way of doing this you could try is to use the 'list group members' action and then a 'for each' loop with a condition then compares job title against your required list. If it's a match send the email:

This relies on you 365 profiles having the correct Job Titles.

Was this reply helpful? Yes No
Verified answer

jason_c_wyatt 93 on 26 Jul 2021 at 14:02:10

Like (2)

Report

Re: How to send email only to selected members of SharePoint group?

Hi,

A low code way of doing this you could try is to use the 'list group members' action and then a 'for each' loop with a condition then compares job title against your required list. If it's a match send the email:

This relies on you 365 profiles having the correct Job Titles.

Was this reply helpful? Yes No
eliotcole 4,280 Moderator on 26 Jul 2021 at 13:42:46

Like (0)

Report
Re: How to send email only to selected members of SharePoint group?

I'm not sure that I have an easy answer off the top of my head, however any answer I do make would likely use the
"Send an HTTP request to SharePoint" action pretty prominently.

Also ... this might assist you with your forward planning on this ... you can create a SharePoint group that contains that subgrouping:
Go to /_layouts/15/user.aspx
Add a new group (ensure you get permissioning right) maybe called something like "DirMgrs"
Add the other groups in to the new one

Otherwise, yeah, good luck ... but perhaps look into what you can do with API calls in the HTTP request. 🙂

Was this reply helpful? Yes No