Get Items odata filter Bad Request returned

[Robg]

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

[v-siky-msft · Accepted solution]

Hi @Robg ,

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

Hope this helps,

Sik

[Robg]

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