List rows using OData filter on formatted date

(0) Share

Report

Posted on by Kosenurm

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')

new_date eq '2023-02-10' and new_desk eq 'LD5'

Any ideas what I am doing wrong? This is driving me mad.

Thanks

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No