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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,824)