Answered

Filter Query for SharePoint List Get Items Not Working

(1) Share

Report

Posted on by CL-30071415-0

Hi,

New to power automate and I cannot get the date part of my filter query correct. Copilot is not helping and none of the community questions seem to have the answer that will correct the issue.

Trying to filter my SharePoint list via two columns, the status and the date. The status is formatted as a choice column and date is formatted as a date column.

If I use just the status filter, the flow runs.

Status eq 'Approve'

When I try to filter by the date for the previous month, I get errors.

Status eq 'Approve' and Date ge startOfMonth(subtractFromTime(utcNow(), 1, 'Month'),'yyyy.MM.dd') or Date lt startOfMonth(utcNow(), 'yyyy.MM.dd')

Any help with the query syntax would be greatly appreciated.

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

David_MA 15,587 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

For filter queries, the date needs to be formatted as an ISO8601 formatted date, which is yyyy-MM-dd. You also need to put each of the expressions within single quotes or it will treat the date as a number instead.
CL-30071415-0 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! The flow is now working with the correct filters :)
Suggested answer

eliotcole 4,441 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi, CL ... I see that there are a number of PDFs attached, but I cannot download files.

Do you have any imagery of your flow, and how it is structured around this part? If so, can you embed them into your original question, above?

Trying to filter my SharePoint list via two columns, the status andthe date. The status is formatted as a choice column and date is formatted as a date column.

If I use just the status filter, the flow runs.

Status eq 'Approve'

When I try to filter by the date for the previous month, I get errors.

Status eq 'Approve' and Date ge startOfMonth(subtractFromTime(utcNow(), 1, 'Month'),'yyyy.MM.dd') or Date lt startOfMonth(utcNow(), 'yyyy.MM.dd')

---

In terms of the actual ODATA filter section, and your specific issue ... I believe that it is because your dates are not within single quotes, and also within an expression.

If you switch it to the advanced view you should be able to be a bit more free and easy with putting it all together:

Once there ... paste this in, it should work:

( Status eq 'Approve' ) and ( Date ge '@{startOfMonth(subtractFromTime(utcNow(), 1, 'Month'))}' and Date lt '@{startOfMonth(utcNow(), 'yyyy.MM.dd')}' )

It might also allow you to switch back to the normal view, too.

Oh ... and you'll note that I set it to 'AND' on the final filter ... because (and I could be mistaken ... but ... ) using 'or' will essentially just get anything 😏

---

You might also just find it easier to create a view which accomplishes your goal (if the filtering is available there) then only add what minimal filtering is needed on top of the view.