Crow Canyon Software Forum
Get Value of Lookup Column
Quote from Matthew Harris on April 11, 2022, 5:42 pmI am using a Query List to retrieve a value for a variable. I need to retrieve the value of a lookup column named Category Title. Instead of just the lookup value of "Printing Issues", the variable is being set with the entire expression value below.
How can I just retrieve the Lookup Value?
Loading Query List items ...Continue Workflow Execution: "None"Query item count: 1Variable: "CategoryRef"Expression: GetCatsTitle##[Category_x0020_Title]Expression Value: {"LookupId":7,"LookupValue":"Printing Issues","TypeId":"{f1d34cc0-9b50-4a78-be78-d5facfcccfb7}"}
I am using a Query List to retrieve a value for a variable. I need to retrieve the value of a lookup column named Category Title. Instead of just the lookup value of "Printing Issues", the variable is being set with the entire expression value below.
How can I just retrieve the Lookup Value?
Quote from supportTeam on April 12, 2022, 1:00 amHi Matthew,
Please use $formatvalue() function in NITRO workflows to get the lookup value.
Syntax: $formatvalue([Placeholder])
Ex: $formatvalue(GetCatsTitle##[Category_x0020_Title])
Hi Matthew,
Please use $formatvalue() function in NITRO workflows to get the lookup value.
Syntax: $formatvalue([Placeholder])
Ex: $formatvalue(GetCatsTitle##[Category_x0020_Title])