Get a distinct set of an attribute for objects meeting the AQL criteria using lookupObjects
I am trying to create an automation to find a set of objects that have a custom date attribute within the current month and email the Contact (another attribute of the objects) their set of objects that meet the criteria.
The problem is that a contact can have more than one object they are a contact for and the {{lookupObjects.Contact.EmailAddress}} understandably returns the Contact's email for each object they have. Looking for a way to get a distinct list of Contacts to loop through so I can only email the Contact their list of objects and not email every Contact the same large list of objects. I also only want to send one email to each Contact with objects that meet the criteria.
Here are the automation steps so far. This was just a test automation. Next step would be to find the distinct list of Contacts and loop through each to find their list of objects and send email. A colleague and I have tried using .distinct in various locations in the {{lookupObjects.Contact.EmailAddress}} smart value with no luck. Splitting the list would not be helpful.
