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

Get Items odata filter Bad Request returned

Hi

I have a simple flow that I am using to get item (when created or modified) in List A and copy it to List B.

Flow is comprised of the following:

  • Trigger "When an item is created or modified" in List A
  • Get items from List B

    Filter Query - Title eq 'Title' (the value Title is from the "Dynamic Content")

  • Runs through a condition etc after this but never gets further.

I am always getting a failure at "Get Items" 

eg The expression "Title eq'testa" is not valid. Creating query failed.

testa is the value in the column returned, I have noticed the double quote at the end but do not know how to handle this error.

 

 

Any help appreciated.

Rob

 

       

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @Robg ,

 

Make sure the Title (Dynamics Content) is wrapped around single quotes shown as follows.

Snipaste_2020-08-27_10-16-19.png

 

Hope this helps,

Sik

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @Robg ,

 

Make sure the Title (Dynamics Content) is wrapped around single quotes shown as follows.

Snipaste_2020-08-27_10-16-19.png

 

Hope this helps,

Sik

View solution in original post

Robg
Frequent Visitor

Hi

Yes that is correct and after a bit of double checking, it seems that on occasion the single quote mark was not sticking at the end.

Save... check ... is it there ... no ? .. edit ... save .. check etc etc.

 

Thanks

 

 

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,985)