cancel
Showing results for 
Search instead for 
Did you mean: 
marcin_o
Nintex Newbie

Use the value of lookup field in the e-mail

Jump to solution

 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?

Labels: (1)
0 Kudos
Reply
8 Replies
ArunPrakash
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

Hello,

 

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

0 Kudos
Reply
marcin_o
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

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

0 Kudos
Reply
cabeza
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

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

0 Kudos
Reply
marcin_o
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

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

0 Kudos
Reply
cabeza
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

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

0 Kudos
Reply
marcin_o
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution

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

1_query_list.pngConfiguration of "Query list" action

2_send_notification.pngConfiguration of "Send notification" action

3_wf_log_history.pngWF history

4_email.pngReceived e-mail

0 Kudos
Reply
emha
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to 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.

0 Kudos
Reply
marcin_o
Nintex Newbie

Re: Use the value of lookup field in the e-mail

Jump to solution
Thanks. That worked out!
0 Kudos
Reply