kyan
Nintex Observer

How to access additional lookup columns in Nintex Forms

​I have a SharePoint list with a lookup column that includes additional fields from the lookup list. In the column settings, I have:

Get information from: Services Request Areas
In this column: Service Area
Add a column to show each of these additional fields:
Point of contact 1
Point of contact 2
ID

My list settings have the following columns:
Service Area
Service Area:Point of contact 1
Service Area:Point of contact 2
Service Area:ID

In Nintex Forms, the List Columns controls has a List Lookup control for the Service Area column but not for the additional lookup fields (Point of contact 1 and Point of contact 2). I can access the Service Area column and display the values in the form.

How can I access the additional lookup fields (Point of contact 1 and Point of contact 2) in the form?

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to access additional lookup columns in Nintex Forms

Hi,

There are two ways to do this.
First is to use cascading lookups. The problem with this is that the user will have to select the selection on each lookup even if there is only one.
The best way to do this would be to use calculated value controls with the lookup() runtime function that filter off of the lookup control that is looking up Service Area and just display the other columns.
0 Kudos
Reply