I am trying to achieve "Cascading Dropdown" functionality on a list in "On-Premises" SharePoint Foundation Nintex Forms 2013 (Version :22.214.171.124).
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)
Stores (List 2, that refers to List 1)
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.