cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
lpetre
Nintex Newbie

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

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. 

Labels: (1)
Tags (2)
0 Kudos
Reply
1 Reply
Automation Master
Automation Master

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

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

Reply