You’re offline. This is a read only version of the page.
379
I have a SharePoint Get Items action in my flow that uses a Filter Query to select specific rows and it is returning the following error.
"status": 400, "message": "The expression \"Pads Expiration date ge '2023-05-04' and Pads Expiration date lt ' 2023-06-03'\" is not valid. Creating query failed.\r\nclientRequestId: f0ab3c48-e5fd-4b17-a253-f42e221091c7\r\nserviceRequestId: f0ab3c48
This is the expression:
Hey @lcdelgado
Instead of the above expression in filter query, try something like this:
PadsExpirationDate ge 'outputs('Today_+_x_days')' and PadsExpirationDate le 'outputs('x_Days_+_30')'
In the above expression the pad expiration date might not match, keep it exactly how you have kept in sharepoint.
One more thing to notice here is, I hope you are only dealing with date here and not time.
I hope this helps 🙂
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
