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.

Solved Solved
0 1 105
1 ACCEPTED SOLUTION

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.

View solution in original post

1 REPLY 1

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.

Top Labels in this Space