"error": {"code": "0x80060888","message": "')'or ',' expected at position 5 in

(1) Share

Report

Posted on by BG-20091720-0

I have a flow that is not playing nice...

I have a flow that goes
Step 1: "when a row is added, modified or deleted" this is a trigger to take the Sample_test_id from the Sample_test table, then
Step 2: " add a new row" this creates a new row on the 'test_results' table it also inputs the 'Sample_test_id' from the 'Sample_Test' table into the lookup column found on the 'test_result' table.
Step 3: "update a row 1" This updates the 'Sample_test' table with the 'Test_result_id' from the 'Test_result' table.

Both 'sample_test_id' and 'test_result_id' are autonumbers formatted as follows
sample_test_id = STid-00101
test_result_id = TRid-00101

Error Code:

{
  "error": {
    "code": "0x80060888",
    "message": "')' or ',' expected at position 5 in '(STid-001018)'."
  }
}

I have tried just using 'sample_test_id' and i have tried /cr002_sample_test1s(sample_test_id)

Categories:

Building flows

Screenshot 2024-1...

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
:Hi,

You selecting the wrong column.

The correct way is the GUID ID

Adjust it to the correct GUID ID and it should work

Was this reply helpful? Yes No
BG-20091720-0 6 on at

Like (0)

Report

SpongYe, Are you reffering to the GUID ID for the sample_test table or Test_result table?

for the 'Test_results' table the only unique idenifier column is called "Test_Results" and it is "cr002_Test_ResultsId" the primary column is "Test_results_id" which is an autonumber with name "cr002_Test_Results_id"

(hindsight is 20-20.... should have had better names)

for 'Sample_Test' table the only unique idenifier column is called "Sample_Test" and it is "cr002_Sample_Test1Id" the primary column is "sample_test_id" which is an autonumber with name "cr002_sample_test_id"

It is currently using /cr002_sample_test1s(sample_test_id)

"cr002_Sample_Test1Id" is the unique identifier for the sample test table.
Sample_test_id is the column i want to pull the value from...

Solved it, Don't name things to similarly to others... its a nightmare.... solved it...

Was this reply helpful? Yes No
SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I mean the sample_test table.

I further investigated your issue and the hyphen (-) could be causing the issue as this is on at position 5 in '(STid-001018)

Certain characters like hyphens can be interpreted in ways that might lead to syntax errors if not properly handled.

Check if this works: /cr002_sample_test1s('sample_test_id')

Otherwise can you check the output of the 'When a Row is added, modified or deleted' and try to look for the @odata.id and use that directly instead of this /cr002_sample_test1s(sample_test_id).

Was this reply helpful? Yes No