Help with list expression

Trying to create a list of emails for a To: field. I amusing the current expression to pull the emails from table:
SELECT(Dealer Contact[Email], AND([Dealership] = [_THISROW].[Dealership],[App. Notifications]=true))

Isn’t working. Any ideas would be greatly appreciated.

Did you use the “Test” button for the expression?

I think you have to wrap the entire thing in CONCATENATE() or TEXT(), to convert the List data type to a single comma-separated Text string.

3 Likes