I have seen several topics similar to mine but have been unable to get this automation working. My goal is to send an email per record in my summary table at the time defined in the “At a scheduled time” trigger. Each record contains, among other fields: 1) Name, 2) Email Address, 3) Lookup field with a list of items, e.g. “item 1, item 2, item 3”. So, the list of items would be different for each record.
At the scheduled time I want to send one email per record to the Email Address field and include the list of items in the lookup field. I was using a Find action to locate all records in my table that have linked records, and therefore have values in the lookup field (using a view to find records). But when I preview my email, I see all the values of all linked records concatenated together, as well as all the email addresses concatenated together. I was hoping for one email per record with values from that record.