Use the value of lookup field in the e-mail

[marcin_o]

 I have a lookup column in the list where the workflow is running. I would like to display the value of this field in the e-mail sent to the initiatior after successful submission.

When using the "Insert reference" -> Item properties -> the value is not available in the e-mail.

Tried using "Set variable" -> List lookup -> Current item -> Field with lookup -> it's not working too.

Do you have any other ideas how to do it?

[ArunPrakash]

Hello,

You can use Query list action item to qeury the current list lookup value and use the same in the e-mail. 

[marcin_o]

@ArunPrakash I used the "Query list" action with following configuration:

List -> Current list

Filter -> ID is equal to {Item Property:ID}

Field -> My lookup column -> store in a variable

Tried both - a single text and number variable.

In both cases the value from the lookup column is still empty.

[cabeza]

set the Variable as text, use log in history  and insert that variable, run the workflow and in workflow history see what is the value that was logged

[marcin_o]

@cabeza Did that as you suggested.

In both cases:

- when I log the value of the variable and

- when I log the value of the lookup column it was correctly logged.

So it seems to be an issue with the "Send notification" action.

[cabeza]

if it logged correctly, then everything should be okey,
if you can share or attach more info, we can have a look into it

[marcin_o]

I attach here the screenshot from my workflow. Hope it helps you to find the reason.

Configuration of "Query list" action

Configuration of "Send notification" action

WF history

Received e-mail

[emha · Accepted solution]

less then ('<') character within the value is misinterpreted by your mail client as a start of HTML tag.

if you sent the mail in a plain text format you'd see correct output.

[marcin_o]

Thanks. That worked out!