Answered

Bad Request - Error in query syntax.

(0) Share

Report

Posted on by JB87

I'm stuck with a flow, the idea is it updates the records status when data is in a specific field i.e. contains data and is not blank. However every time it runs I get this errors

"code": "0x80060888" Bad Request - Error in query syntax.
I've tried a few different solutions from these forums however they have not worked, what else can I try?
I have a screenshot of the flow currently.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JB87 ,

Usually, we use empty to determine if a value is null.

Please modify your condition.

empty(triggerOutputs()?['body/logic column name'])

Best regards,

Rimmon

Was this reply helpful? Yes No
JB87 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-mengmli-msft, I had made that change and it is still not working. This issue seems to be in the update a row. Rather than the condition step.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JB87 ,

Is the problem the same as the one in your question? If not, please show a screenshot of the problem. Also, which dynamic content are you using in RowID field?

Best regards,

Rimmon

Was this reply helpful? Yes No
JB87 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
Its the original question, RowID is the Status Reason where the status reason is then Externally Forwarded on the Cases table.
Thanks

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JB87 ,

The Row ID should be unique identifier of row.

You should have something similar to the image below in your dynamic content.

Please select it in Row ID field.

Best regards,

Rimmon

Was this reply helpful? Yes No