MS Flow expression is not valid

Like (0) Share

Report

Posted on 4 Apr 2023 15:09:56 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:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

lcdelgado 379 on 04 Apr 2023 at 16:10:34

Like (0)

Report

Re: MS Flow expression is not valid

Its only date format

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,482 on 04 Apr 2023 at 16:06:37

Like (1)

Report

Re: MS Flow expression is not valid

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