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.
Solved! Go to Solution.
@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.
@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.
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,
Thank you, this worked perfectly!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
31 | |
28 | |
27 | |
21 | |
10 |