cancel
Showing results for 
Search instead for 
Did you mean: 
cjones69
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
Reply