Unanswered

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

(0) Share

Report

Posted on 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:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

eliotcole 4,363 Moderator on at

Like (0)

Report
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
Verified answer

jason_c_wyatt 93 on at

Like (2)

Report

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,363 Moderator on at

Like (0)

Report

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