Syntax Error - Sql Get Rows - Filter Rows OData

[TesDA]

I have a flow moving data from the common data service to sql server.

In the get rows function I am trying to filter to determine if the Project ID already exists in SQL Server, if it does - modify that row, if it doesn't add a new row.

In my Get Rows v2 (sql) I have under filter query: Project_x0020_ID eq @{items('Apply_to_each')?['crf02_projectid']}

This is giving me the below error:

Syntax error at position 30 in 'Project_x0020_ID eq 100XXX.XX.XXXX - Man Power Study'.
inner exception: Syntax error at position 30 in 'Project_x0020_ID eq 100XXX.XX.XXXX - Man Power Study'.
clientRequestId: xxxxxx.....

In sql the column is [Project ID]

Any thoughts on a solution to get past this error?

[ChristianAbata · Accepted solution]

hi @TesDA  could you try with roject_x0020_ID eq 'PROYECT ID'  with '' 

[TesDA]

I'm getting the same syntax error:

Syntax error at position 30

I tried:

Project_x0200_ID eq @{items('Apply_to_each')?['crf02_projectid']} with ''

and

'Project ID' eq @{items('Apply_to_each')?['crf02_projectid']} with ''

and

@{items('Apply_to_each')?['crf02_projectid']}' eq Project_x0200_ID    - on this one I added an apostrophe - syntax error at position 10 on this one

No luck

[TesDA]

Actually your answer was so obvious I thought it had to be more complicated. Thank you!