Hi there!

I'm struggling with Nintex form on SHP 2013 - I want to filter dropdown menu based on selection in another dropdown that is taken from lookup column.

Config:

List 1: contains a single column with location names

List 2: contains project name column (string) and project location (lookup from list1) columns (plus some other status columns, but it's irrelevant here)

List 3: reporting list where I build up my form that looks up on List 2 projects and takes 2nd column of project location in addition. The form has 2 fields:

• location (lookup from list 1)
• project name (lookup from list 2)

Now - if you select location A, then project name control should be filtered out by this location name (so i see all projects, but these which were assigned to location A on List 2). 

Is it doable? I've been trying to filter It out many ways, but all I could achieve is ...opposite - select location and see only this location's assigned projects, placing it in not() broke the thing completely.