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

Re: Setting Value of Field based on Another

I know this is years old, but I've run into this issue in the past as well and realized a solution that may help others. The lookup function is as shown below:


lookup(list title, column to filter on, value to filter on, output column)
My value to fiter on was a lookup selector (not a direct item property) and when I added it directly into the formula as shown, it did not return anything. I finally figured out that this was because it was a lookup selector and it had to be parsed.
parseLookup([array or single lookup value], [optional bool showText])
So using the example in the OP, this is what finally worked for me:
lookup("Countries", "ID", parseLookup(Country), "TerritoryCode")
0 Kudos