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! Go to 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.
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.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |