web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error in get items fil...
Power Automate
Answered

Error in get items filter query

(0) ShareShare
ReportReport
Posted on by 26

My flow worked for months and all of a sudden stopped. I have confirmed the flow works perfectly if I remove the filter query, so I know that is what is causing the error and I know it's not due to the formatting of the field since it was copied from the Order By field, which is working.

 

I have tried adding spaces before and after "gt" with not luck. Below are screen shots of the error message, the flow, and the SharePoint settings page for the date field.

 

Capture.JPGCapture2.JPGCapture3.JPG

Categories:
  • Verified answer
    RobElliott Profile Picture
    10,545 Super User 2026 Season 2 on at

    @kels89 you need to wrap the utcNow expression in your filter query in single quotes ' ' as in the example below. That's why it's not working.

    filterQuery3.png

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

     

  • v-bacao-msft Profile Picture
    Microsoft Employee on at

     

    Hi @kels89 ,

     

    As suggested by @RobElliott , you should add space in front of and behind gt.

    And you need to add a single quote outside the expression.

    Please check this blog to get more details about Filter Query:

    https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

    Feel free to let us know if you have any other questions.

     

    Best Regards,

  • kels89 Profile Picture
    26 on at

    Thank you, this worked perfectly!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard