cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djoel
Frequent Visitor

MS Flow expression is not valid

 

I have a a SharePoint Get Items action in my flow that uses a Filter Query to select specific rows and it is returning the following error. The location_code is a text field so why is the expression shown below invalid?

 

{
"status": 400,
"message": "The expression \"location_code eq 056\" is not valid.\r\nclientRequestId: ..."
}
1 ACCEPTED SOLUTION

Accepted Solutions
SandyU
MVP

Hi @djoel 

Can you try wrapping your 056 in single quotes? e.g. location_code eq '056'

If the 056 is coming from dynamic content, you'll need to put a single quote on either side of the dynamic content token.

 

Does this help you...?

 

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

3 REPLIES 3
SandyU
MVP

Hi @djoel 

Can you try wrapping your 056 in single quotes? e.g. location_code eq '056'

If the 056 is coming from dynamic content, you'll need to put a single quote on either side of the dynamic content token.

 

Does this help you...?

 

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

djoel
Frequent Visitor

Yes, that was it.  Thank you for your response to my question.

Great @djoel - happy to hear it!

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

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