Flow: Send email to those user who are in the group

Question

EDIT:

I'm creating a flow where the users in the Group will received an email via flow based on certain conditions:

I have done the following steps:

1. Configure start

2. "Get Records" from object "Group Member"

3. "Loop" through "Group Member" results

3.1 Use "Assignment" to add the user email address to the "Collection Variable"

3.3 (after last item) "Action" to send email and use the "Collection Variable" as Email Addresses (as long as the combined number of email addresses is five or fewer.)

Is there a way or workaround to send email individually to a user from a public group?

When I debug I see that

Result

{!User_Email} = "[]"

Answer 1

So, you are going to need three Get Records elements

Get Records 1

• Query Group for yourGroupName

Get Records 2

• Query GroupMember where GroupId = result.Id from Get Records 1

Loop

• Build a collection variable of strings for each GroupMember where UserOrGroupId starts with 005 (meaning it is a User, not a Group)

Get Records 3

• Query User where ID = the collection variable built in the loop. This will yield 1 or more User.Email which is what you need.

---

Even if you used Apex, it would take two queries because the following isn't supported on GroupMember (no support for the UserOrGroup relationship as the schema describe doesn't expose that relationship)

SELECT Id, 
     TYPEOF UserOrGroup 
         WHEN User THEN Email 
     END 
   FROM GroupMember 
   WHERE UserOrGroup.Type = 'User' AND
         Group.Name = 'yourGroupName'