Answered

Filter Query compare dates error

(0) Share

Report

Posted on by knparksnyc

Hello I'm trying to compare dates in a filter query for a SharePoint get items. This the event date format

  "EventDate": "2015-09-14T17:30:00Z"
the expression im comparing it to formatDateTime(utcNow(),'yyyy-MM-ddT00:00:01Z')
Is their something I'm doing wrong?
 
Thanks.

Error Receiving: The expression "EventDate eq 2024-12-19T00:00:01Z and EventDate eq 2024-12-ThursdayT23:59:59Z" is not valid. Creating query failed.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @knparksnyc

I think you have forget to put single quotes around the expression as Odata filter query requires that.

Expression should have been like this (for comparing with single date)

DateColumn eq 'DateValue'

Also the second date expressions seems to be incorrect

EventDate eq 2024-12-19T00:00:01Z and EventDate eq 2024-12-ThursdayT23:59:59Z

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
RT-20121435-0 4 on at

Like (0)

Report
Copy link

Link copied!

maybe '' is missing.
try adding '@{formatDateTime(utcNow(),'yyyy-MM-ddT00:00:01Z')}'

Was this reply helpful? Yes No
Verified answer

MarkRahn 1,351 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You need to add single quotes around the formatDateTime like this:

You can see some examples of using Filter Query here:

https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files#filter-queries

which has an example of using Dates.

Let me know if you need more help.

This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊

Thanks
-Mark

Was this reply helpful? Yes No