Date comparison in Filter of List Rows

(0) Share

Report

Posted on by bdherh1

I have a date in my table 'bdh_dateworked' that has a value of 03/07/2023

My filter is as follows (output from test)

But the filter is not grabbing the record.

I'm sure this is a dumb request but this is all fairly new to me (Dataverse and PowerAutomate)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Have you tried something like this?

bdh_dateworked ge 2023-03-07T00:00:00-00:00 and bdh_dateworked lt 2023-03-08T00:00:00-00:00

Was this reply helpful? Yes No
bdherh1 74 on at

Like (0)

Report

Thanks Drew

One of the dates is coming from a List Rows above and both are defined in the database as Date Only.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
ahh, got it. A couple more things to check / try:

Did you try with single ticks around the Date Worked dynamic field?

If this doesn't work, try to do a ge to verify it returns results for everything above this date

Also you might want to check on the field in Dataverse to see if it is User Local for Behavior of the field (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/behavior-format-date-time-attribute)

Was this reply helpful? Yes No
bdherh1 74 on at

Like (0)

Report

So I tried the single ticks and that did not work.

I changed the eq to ge and that DID work, but its not what I need. Because there will be rows that are greater that I dont need

I looked and it is set to Date Only instead of User Local

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Couple things:

I would retrieve the field and verify what is reflected, even though it is Date Only, since you have User Local this might cause issues.

Try the following in your syntax for the filter rows

bdh_dateworked ge DateWorked and bdh_dateworked lt addDays(DateWorked,1)

Was this reply helpful? Yes No
bdherh1 74 on at

Like (0)

Report

thank you

I tried this, and actually thought about it, but it is giving me this error on the addDate function

and bdh_dateworked lt addDays(triggerOutputs()?['body/bdh_dateworked'],1)

The DateTimeOffset text '2023-03-08T00:00:00.0000000' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range.

Was this reply helpful? Yes No