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?
Solved! Go to Solution.
hi @TesDA could you try with roject_x0020_ID eq 'PROYECT ID' with ''
Proud to be a Flownaut!
hi @TesDA could you try with roject_x0020_ID eq 'PROYECT ID' with ''
Proud to be a Flownaut!
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
User | Count |
---|---|
96 | |
40 | |
25 | |
22 | |
16 |
User | Count |
---|---|
129 | |
51 | |
48 | |
35 | |
24 |