Sending an Email from Schedule Report when a Column value is selected in the list

[Scott_Hall]

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.

[LeventK · Accepted solution]

Scott_Hall:

SELECT((Contact[Email], IN[Communications], “Quote Reminder”), TRUE)

@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
)

[Scott_Hall]

@LeventK Thank you. Those expressions failed…“couldn’t fine column [_Thisrow].”

I trimmed it to:

SELECT(Contact[Email],CONTAINS([Communications],“Quote Reminder”),TRUE)

It appears to like that better. Does that make sense?

[LeventK]

@Scott_Hall
As you are triggering the workflow rule just from that table, no need to use [_THISROW], your expression is fine. I have edited my expressions under the post as well.