If in the table Contacts, the column of enum list type [Communications] has the “Quote Reminder” value selected, I would like the report to send the contact an email.
Using this expression to no avail plugged into the “To” field in the report action.
SELECT((Contact[Email], IN[Communications], “Quote Reminder”), TRUE)
Any help would be appreciated. I’ll need to build 6 to 8 reports based on a variation of this expression.
Please and thank you.
Solved! Go to Solution.
@Scott_Hall you are using the IN expression in a wrong way and the syntax of the whole expression is not correct. Below expression will work better:
SELECT(
Contact[Email],
CONTAINS(
[Communications],
"Quote Reminder"
),
TRUE
)
OR
SELECT(
Contact[Email],
IN(
"Quote Reminder",
SPLIT(
[Communications],
","
)
),
TRUE
)
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |