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 on at

Like (0)

Report
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

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 on at

Like (0)

Report

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

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 on at

Like (0)

Report

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