cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kels89
Helper I
Helper I

Error in get items filter query

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

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

@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.

 

View solution in original post

3 REPLIES 3
RobElliott
Super User
Super User

@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
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you, this worked perfectly!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,062)