You’re offline. This is a read only version of the page.
802
Hi,
I have a dataverse table where I want to list rows with an OData filter.
The columns to include in the filter are new_date and new_desk. The date column is of type Date Only, and the desk column is text.
The date in Dataverse appears, formatted, as dd/MM/yyyy, but when I have listed rows on the entire table to see the date value itself, it is in format yyyy-MM-dd.
Therefore, my OData query at the moment is below, but anything I try returns a BadRequest error. Note that I am using the Add to Time action previously, with a Base Time of utcNow(), adding 1 day, using the output from this in a Convert Time Zone action, and the format for this is yyyy-MM-dd. Therefore, the date in the below is created via expression formatDateTime(body('Convert_time_zone'), 'yyyy-MM-dd')
Share
Reportnew_date eq '2023-02-10' and new_desk eq 'LD5'
Any ideas what I am doing wrong? This is driving me mad.
Thanks
K.
I'm guessing at this for you to test,
Is the dataverse table actually carrying a time of midnight that gets scrubbed off when it is pulled into power automate?
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/behavior-format-date-time-field
In the microsoft article it says that a Date Only field "The time portion of the value is always 12:00AM."
So maybe if you include the time of midnight in the filter it might work?
All responses (
Answers (
