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?
Solved! Go 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.
@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.
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
@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.
if it logged correctly, then everything should be okey,
if you can share or attach more info, we can have a look into it
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
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.