+2
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?
+2
Hello,
You can use Query list action item to qeury the current list lookup value and use the same in the e-mail.
+2
@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.
+3
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
+2
@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.
+3
if it logged correctly, then everything should be okey,
if you can share or attach more info, we can have a look into it
+2
I attach here the screenshot from my workflow. Hope it helps you to find the reason.
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.
+2
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
