I am attempting to filter a query where a column is equal to selections from a list lookup. Is this possible?
My ultimate goal is to create a collection of email addresses from this query, join them, and send a notification to those email addresses.
I have a Category list, Group list, and then contact list.
My form cascade a Group column based on the Category selected. (Each contact is assigned to a group in the Contact list).
When I select a group or groups on the cascading column, I then want to send a notification only to those emails related to the selected groups.