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

OData Filter Query on Get Items - "expression: .... not valid"

Hello,

 

I have two recurring flows that sends out an e-mail for certain items on a Sharepoint List, but one of them is failling

 

This issue is somewhat confusing because they are two identical flows that have an odata filter query on a  Get Items action but one of them is failing every time it runs (once a week), but the other is succeeding, despite them being the same query just with a different number for "addDays" listed. Here are the two filter queries and the screenshot is the error message I'm getting when the GetItems action fails. Any idea why this could be happening?

 

Successful flow: 

LaunchDate eq '@{formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd')}' and Status ne 'GO'
 
Failed flow:
LaunchDate eq '@{formatDateTime(addDays(utcNow(),4),'yyyy-MM-dd')} and Status ne 'GO'
 
dsmcwhir_0-1617902816541.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
soysalf
Resolver I
Resolver I

Hi @dsmcwhir ,

' character is missing on your filter query

LaunchDate eq '@{formatDateTime(addDays(utcNow(),4),'yyyy-MM-dd')}

View solution in original post

2 REPLIES 2
soysalf
Resolver I
Resolver I

Hi @dsmcwhir ,

' character is missing on your filter query

LaunchDate eq '@{formatDateTime(addDays(utcNow(),4),'yyyy-MM-dd')}

View solution in original post

Thank you! That worked. So simple.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,237)