List Lookup Control Filtered by List Lookup Control (Dates)

  • 15 June 2021
  • 3 replies
  • 71 views
R
Badge +4

Hello

 

I have the following two lists:

 

List1, columns: Title (string), Location (choice), Date (date only)

 

Title | Location | Date
------------------------------------
A | 1 | 01/07/2021
B | 2 | 01/07/2021
C | 3 | 02/07/2021

 

List2, columns: Title (string), Date (date only)

Title | Date
--------------------
A | 01/07/2021
B | 02/07/2021
C | 03/07/2021

 

On my Nintex form, I have List Lookup control with the following filtering settings

 

18204i5E94EEC4ED611532.png

Any 

My goal is to filter List1 based on selected date from List2 for example:

I select 01/07/2021 then the filter will return items A and B on the dropdown-list for List1

 

Unfortunately, it does not work. Both date values appear to be in the same format but when I select the date from List2 control then the dropdown list based on List1 is empty. 

 

Any idea what am I doing wrong?

3 replies

K
Userlevel 3
Badge +12

Hi


I understood that List2 is main/parent and List1 is child. Is your List1 have a lookup field pointing to List2?

R
Badge +4

Actually no, list 2 is just a list with some dates.


 


On the form I have a List Lookup Control that creates a drop down list with dates from list 2.


 


I want to use this control to filter the other List Lookup Control that has drop down list with values from List 1.


 


It works fine when I create Choice control and I enter the dates in format yyyy/MM/dd but it does not work when it is a List Lookup. 

R
Badge +4

This works


 



 


 


But this doesn't work


 




 


 


 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings