Power Platform Community Forum Thread Details

Hi community!

I could support putting examples of how to fill the fields of the option "update row" in sql, since every time I run the flow selecting this option shows me the following message:

{
"status": 400,
"message": "Invalid Expression.\r\n inner exception: Token Equal
expected. Start position: (666, 122). End position (666, 123).\r\n inner
exception: Token Equal expected. Start position: (666, 122). End position
(666, 123).",
"source": "127.0.0.1"
}

I think it's because I did not fill the fields correctly.

I would greatly appreciate your support

Regards!!!

Categories:

Using connectors

Hi RafaelCDev,

I tried to create a flow using this template:
https://flow.microsoft.com/en-us/galleries/public/templates/24ae48507e6f11e68a3df3f52190b805/when-an-existing-list-item-is-modified-update-a-sql-row/

I configured the flow looks like below, but when the flow was triggered, I got the same error with you:

When we configure the flow, we know that “Unique Identifier of the row” is asked in the Row id field.

Could you try to get the Unique Identifier of the row to see if it works? I have seen an article about “Using uniqueidentifier Data”, hope this could be a reference for you:
https://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx

Please reply me back if you got a result.

Best regards,
Mabel Mao