Skip to main content
Nintex Community Menu Bar

Trouble using Lookup on repeating section on Nintex Form 2016

  • November 8, 2020
  • 3 replies
  • 20 views

Forum|alt.badge.img+1

I have a list of Computers that we are being billed for. I have a Nintex form that I have a repeated section that will display all the computers assigned to a particular person (Display Name). On the form, it calculates the Display Name. I attempted to create rules that would populate the computer Make/Model, Serial Number and questions to verify computer info is accurate

9403i9B9A0619E6BAE508.jpg

 

The List

9404i185EFDB1E2048E74.jpg

 

The properties of the calculated field that shows current user:

9405i9006486B8A75DA60.jpg

 

I created the following rule on the Make/Model field

9406i2C0DFB98900818A9.jpg

 

When I attempt to preview the form the value above does not display - instead I get a #Value error. What am I doing wrong?

 

3 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • November 9, 2020
Hi,

The third parameter DisplayName does not look like its using the named control as its not coloured red.
As you have the same user multiple times in your list which item would you expect to be returned?

Forum|alt.badge.img+1
  • Author
  • November 10, 2020

Thank you - that worked!

 

Any idea on why only one computer is displaying as opposed to multiple?


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • November 12, 2020

Try adding the fifth parameter for the lookup runtime function 'true'.

Example

lookup("theList","theColumn",filtercontrol,"returnColumn",true)