I am having trouble creating an automation to send several consecutive emails based on sets of found records.
My basic workflow is shown in the screenshot.
1 on a trigger
2 find a set of records related to email recipient A
3 Send an email to recipient A with message content from the set of records
4 find a new set of records related to email recipient B
5 Send an email to recipient B with message content based on the most recent set of records.
When I test this workflow, steps 1 to 4 work fine, however step 5 includes the records from the step 2 instead of step 4.
Can anyone suggest a way of ensuring the correct records are included with each email.