Skip to main content

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?

Hi



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

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. 

This works



 





 



 



But this doesn't work



 







 



 



 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings