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)
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.
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
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.
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)
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
I gave it a shot, still appearing as blanks.
BTW, thank you for looking into this!
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
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
Alright, I've tried it and these are the results:
41 values as expected.
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.
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
User | Count |
---|---|
252 | |
126 | |
104 | |
50 | |
49 |