List Lookup control referenced in lookup() function not returning data.

[lpetre]

Using Nintex Forms 2016 for SharePoint and SharePoint Server 2016.

I have custom list "Places" with columns Number, RefNumber, Contact, and others. Places contains many rows and needs to be added to occessionally. I want to have my form structured such that upon adding a row in Places automatically adds the new item to the choice dropdown. 

I am using a form as a dashboard which displays column data based on which Place is selected.

What works (have to add new Place.Number to Choice dropdown manually): 

Control - Choice | Location: values are copied from Places.Number and selected from a dropdown.

Control - Calculated Value | Display: lookup("Places","RefNumber",Location,"Contact")

Display correctly shows Contact for the selected Location. 

What does not work (desire to have dropdown update when new Place is added):

Control - List Lookup | Location: column Places.Number selected from a dropdown.

Control - Calculated Value | Display: lookup("Places","RefNumber",Location,"Contact")

Display remains blank. 

Can anyone shed some light on this for me?

Thank you. 

[emha]

have look on parseLookup() runtime function

https://help.nintex.com/en-US/nintex2016/current/#sp2016/Forms/Designer/RuntimeFunctions.htm%3FTocPa...

lookup control evalutes to ID#;Value

the parseLookup() function picks either ID or Value out of it which you can then use as a value to filter by