Skip to main content
Nintex Community Menu Bar

I have three dropdowns on my form that are all list lookups

1. Service Area
2. Division
3. Section

Problem I have is there is a Division in each Service Area (called "Administration" but they have different sections under them.  Since Nintex only allows us to filter on one field haw can I get it to filter on Service Area and Division rather than just division?

Data example is as follows:

18136iD8CA6BA9A154DB69.jpg

We use Nintex for SharePoint 2013 on Prem

We have three lists:

1. Service Areas (just one column - Service Area)
2. Divisions (with two columns -  Service Area and Division)
3. Sections (with two columns -  Division and Section)

 

 

Hi,
Update your "Sections" list with 2 lookup columns, one pointing to "Service Area" list and the other pointing to "Division" list. This way it allows you futher filter.
So, when you select a "Service Area", it filters "Divisoins", and when you select a "Division", it filters required "Section".

Reply