AnsweredAssumed Answered

Cascading Dropdown in Nintex Forms - SharePoint 2013 (On-Premises)

Question asked by ksubburam on Feb 20, 2017
Latest reply on Mar 5, 2018 by mark.viglione

I am trying to achieve "Cascading Dropdown" functionality on a list in "On-Premises" SharePoint Foundation Nintex Forms 2013 (Version :2.9.3.1).  

 

Had followed all the instructions as provided in the Cascading drop downs and Nintex Forms for SharePoint link, but doesn't seem to be working.  Below are the Lists that I had created:

State  (List 1)

Title

AZ

IL

OR

 

Stores (List 2, that refers to List 1)

Title         State

PHX            AZ

TUC            AZ

SCH            IL

 

Created a third List "StoresInState" and included two "Single Line or Text" field to store the values from the State and Stores List.  

 

In "StoresInState" List, selected the "Configure Nintex Form button from Ribbon", and had included 2 List Lookup Fields, for State and Stores respectively onto the Form. 

 

For the "State List LookUpField", provided the below settings :

     a. Name : MyState

     b. Source List: State

 

For the "Stores" List, provided the below settings :

      a. Name: MyStores

      b. Source List : Stores

      c. Under "Filtering" :

 

After publishing the form, the values from the "State" list are appearing fine in the "MyState" dropdown and when I select a value in "MyState", the issue is that the "MyStores" drop down isn't populated with any values and remains empty, as per the below image:

 

Upon digging deep in the Sharepoint Logs, I found the below error, wherein its complaining that the 'State'

 

02/20/2017 20:25:55.52 w3wp.exe (0x39D8)                       0x1500 Nintex Forms                   Front End                     00000 Unexpected The lookup list 'State' could not be found in web '/sites/TestSite/' with error: System.NullReferenceException: Object reference not set to an instance of an object.     at Nintex.Forms.SharePoint.WebControls.BaseLookupControlV1.get_Web()     at Nintex.Forms.SharePoint.WebControls.BaseLookupControlV1.get_List() 09f6d69d-841f-a07e-a1f9-cec9912b57f3

 

Out of curiosity, tried to set the Filter for "MyStores" field to "By a specificed value" and defaulted the value to "AZ" (per the below image),

Upon previewing the form, the values in the "MyStores" are populated with the proper values mapped for "AZ"

 

The above testing proves that the Nintex Forms engine is able to connect and apply the filter on one scenario, but isn't able to filter dynamically.  Not sure if anyone else has encountered the above error/scenario and any help/guidance to resolve the issue is much appreciated.

 

Thanks,

Karthik.

Outcomes