In Flow Designer, how do I email multiple admins when the article status changes to “xxxx”

鳴鏑張
Giga Contributor

I'm working on a Flow Designer flow that needs to send a notification email to multiple administrators when a article status changes to "xxxx"

 

Current Flow Structure 
1. Trigger: Record Created (xxxx table)
  Condition: Status is 'xxxx'

2. Look Up Records: Get group members from sys_user_grmember

3. If: Check if group has no members (record count = 0)
└─ then4. Send Email: Notify "updated by" user that email was not sent
5. Else: If group has members
└─ 6. For Each: Loop through group members
     └─ 7. Look Up Records: Get user details for each member
     └─ 8. For Each: Loop through user details
         (Trying to collect users who meet BOTH conditions here)
9. Send Email: Send to collected addresses (OUTSIDE all loops)

The flow needs to send email to users who meet BOTH conditions:
1. User is a member of the group (from step 2)
2. User belongs to the same "create team" group as the "updated by" user

That's why step 7 (Look Up Records) is needed - to filter users by checking if they belong to the same team as the updated by user.

Important Constraint
- Cannot use group email address
- Must send to individual user email addresses
- That's why we need to collect individual emails from qualifying users

 

Problem 1: At 8. For Each: Loop through user details. Only the latest user is collected, not all users

Problem 2: Data Pills Not Available
In Step 9 (Send Email - outside all loops), I cannot access the Data Pills from Step 8 (inside the For Each loop)
- The Data Pill picker does not show data from inside the For Each loops
- Cannot reference loop iteration data outside the loop scope

0 REPLIES 0