I am sending a workflow e-mail.
I want the E-mail reply to address to be the same as the corresponding [trainer E-mail]
The workflow is referencing a table called Candidates
The candidates table references the table Campaign
The table Campaign references the table Trainers that contains the [Trainer E-mail]
Iโm sure there is a way to pull the correct e-mail address, but I just canโt figure out the right path.
Andy
Remove the quotes from around [Trainer E-Mail]
.
The app says โUnable to find Trainer E-mailโ
The problem is that "[Trainer E-Mail]"
is a Text value with the literal content, [Trainer E-Mail]
, which is not in any way a valid email address. It is not a column value reference as I suspect you intend. Removing the quotes makes it a column value reference, but the error suggests there is no column named Trainer E-Mail.
If you look at the screenshots, you will see my dilemma.
Somehow I need to pull the Trainer E-mail from the associated campaign that is associated with the Candidate.
Try this as the Reply To expression for the workflow:
LOOKUP(
LOOKUP(
[_THISROW].[Campaign],
"Campaign Info",
"Campaign ID",
"Trainer Name"
),
"Trainers",
"Trainer Name",
"Trainer E-Mail"
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |