Date in Lookup Column not appearing

[EmS23]

Hi All,

I am creating a form where the user will select the dates from a lookup column. I only need the user to see items that have been created on the same day.

I have this formula another user helped me create, but although there are no errors, the drop down does not display ANY choices.

This is the formula I'm using:

   ForAll(Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked'),
        Text(DateValue(Value)) in Filter(
            'Form 117 CCP # 3 Carcass Zero Tolerance Check',
            Created >= Today()
    ).Created)

Here is proof that it works properly:

When I however on 'Created' I see the option appear from today.

When I however outside all of the parenthesis, all of the values appear as false, even the value that should return as true.

Is there anything I can do to improve my formula?

If you know of a way to simply sort these dates in descending order, that works too!

Edit: I have found a solution to the second question, a way to sort the dates in descending order. 

Sort(Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked'), Value, Descending)

[PG_WorXz10]

Hi @EmS23 ,

Could you please once check the filter date result you got is an exact match in backend ? This value should be exactly match than only you will get true instead of false. 

[EmS23]

Hi @PG_WorXz10 ,

Yes, this only value is the correct value, but it appears as false. So I'm thinking one of my tests must be incorrect in the ForAll formula I'm using. 

[PG_WorXz10]

@EmS23 

Try without converting the date value in text.

 ForAll(Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked'),
        Value in Filter(
            'Form 117 CCP # 3 Carcass Zero Tolerance Check',
            Created >= Today()
    ).Created)

[EmS23]

I gave it a shot, still appearing as blanks.

BTW, thank you for looking into this!

[PG_WorXz10]

Hi @EmS23 ,

Just to debug do you mind adding below code into any temporary gallery to see the values ?

Choices([@'CCP 3 Direct Observation Verification'].'CCP3#DateChecked').Value

[EmS23]

Alright, I've tried it and these are the results:

41 values as expected.

[PG_WorXz10]

@EmS23 

As you can see the date format in both the case are different the filtered value is in mm/dd/yyyy hh:mm:ss AM/PM (12hr) and the gallery format is mm/dd/yyyy hh:mm:ss (24 hr). If you make the format same you will value in the dropdown.