Answered

MS Flow expression is not valid

(0) Share

Report

Posted on by lcdelgado

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:

concat(concat('Pads Expiration date',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Pads Expiration date',' lt ','''', outputs('x_Days_+_30'),''''))

I appreciate any suggestions, I'm still learning on how to use flows

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No
lcdelgado 379 on at

Like
a
(0)

Report
Copy link

Link copied!

Its only date format

Was this reply helpful? Yes No