cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Getting Position Error during List record Account

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 ?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Getting Position Error during List record Account

Hi @onyebuchiboss 

 

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

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

5 REPLIES 5
Highlighted
Helper II
Helper II

Re: Getting Position Error during List record Account

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

Highlighted
Super User III
Super User III

Re: Getting Position Error during List record Account

Hi @onyebuchiboss 

 

Could you please post your flow screenshot?

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Helper II
Helper II

Re: Getting Position Error during List record Account

@abm Look at the below:

capture.pngcapture1.png

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

items('Apply_to_each')['Constituency']
Highlighted
Super User III
Super User III

Re: Getting Position Error during List record Account

Hi @onyebuchiboss 

 

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

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Helper II
Helper II

Re: Getting Position Error during List record Account

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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,615)