Rudixx
Forms Fledgling

List Lookup Control Filtered by List Lookup Control (Dates)

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

 

Rudixx_0-1623768231972.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?

0 Kudos
Reply
3 Replies
kchaluvadi
Workflow Veteran

Re: List Lookup Control Filtered by List Lookup Control (Dates)

Hi

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

0 Kudos
Reply
Rudixx
Forms Fledgling

Re: List Lookup Control Filtered by List Lookup Control (Dates)

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. 

0 Kudos
Reply
Rudixx
Forms Fledgling

Re: List Lookup Control Filtered by List Lookup Control (Dates)

This works

 

Rudixx_0-1625215094618.png

 

 

But this doesn't work

 

Rudixx_1-1625215245110.png

Rudixx_2-1625215476160.png

 

 

 

0 Kudos
Reply