Unanswered

Error in get items filter query

(0) Share

Report

Posted on by kels89

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RobElliott 10,313 Super User 2025 Season 2 on at

Like (0)

Report

Re: Error in get items filter query

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

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.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: Error in get items filter query

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,

Was this reply helpful? Yes No
kels89 26 on at

Like (0)

Report

Re: Error in get items filter query

Thank you, this worked perfectly!

Was this reply helpful? Yes No