Getting Position Error during List record Account

[onyebuchiboss]

Someone please help, I am trying to retrieve records from CDS, i have a filter query in the Action like this : 

name eq items('Apply_to_each')['Constituency']. This action is in a loop, and the constituency in the function is the name of a lookup record in an excel spreadsheet, but during execution, it brings up the below error :

"Syntax error at position 15 in 'name eq A Datum Integration'.",

What I'm I doing wrong ?

[onyebuchiboss]

@abm @yashag2255 Please you wanna take a look at this ?

[abm]

Hi @onyebuchiboss 

Could you please post your flow screenshot?

Thanks

[onyebuchiboss]

@abm Look at the below:

The the second Image is where it is failing. The function is this : 

items('Apply_to_each')['Constituency']

[abm · Accepted solution]

Hi @onyebuchiboss 

Under the filter query add a single quotes between the string name eq 'xxxx'.

Thanks

[onyebuchiboss]

lool funny how a single quote could hold me back this long. Thanks Mate. @abm