Hello! I have a Dataverse table Test with a Test.Date DateTime column. I use Test.Date as a source for a dropdown DDDate, and then I have a form which uses the following as its item:
LookUp('Test', 'Date' = DateTimeValue(DDDate.SelectedText.Value))
This works, but it seems like there should be a way to skip the text conversion and look up on the DateTime directly, since both the front- and back-end are aware of the data type. Is there?
(NOTE, I could simply set the item to DDDate.Selected but say my actual use case is more complicated - like I want to add a reduction formula later - and so I need to use LookUp().)
Thanks!
