dperani
Forms Fledgling

Problem with 3 cascading dropdowns with same name in second dropdown requiring different list in 3rd

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:

SADivSec.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)

 

 

0 Kudos
Reply
1 Reply
kchaluvadi
Design Canvas Artiste

Re: Problem with 3 cascading dropdowns with same name in second dropdown requiring different list in

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".
0 Kudos
Reply