Skip to main content

Hi all, 

I’m creating a List and Form, say List A and Form A. In Nintex list settings, I’ve created a column of type ‘Lookup’ whose drop-down values are from another list, say, List B. Is it possible to filter through these drop-down values such that each value is associated with a name in List B? That is, when a user enters his name in Form A, only values associated to his name are listed in the Form A Lookup drop-down values. 

Thanks for any help!

Regards.

I’m assuming List B has a column you want to compare this name to. Like, List B has at least two columns, one of which is the one you source for the drop-down, and the other being the column with names. In this case this is possible on the Nintex form of List A.

Look on the Nintex form of List A for the dropdown control settings for the List Lookup by double-clicking on the lookup element on the form. There should be a Filter section.

  • Filter available selections based on “The value of a control element” (or something similar to that, I have the Dutch version).
  • For the WHERE-field, type the exact name of this names column from List B, the one you want to compare the names to.
  • Filtered on control element (select the control element from the List A Nintex form that should match the value from the column on List B)

In my experience this works. It will only show values to the user in the lookup dropdown from items where the name comparison is a match.


This works! Thanks very much!


Reply