We have a Power App canvas app. It use SQL server online as datasource. One of the button can add new record to a table. The syntax is like
Patch('mysqltable',{Name: txtMyName.Text, UserID: Hidden_UserID.Text})
It works for a while already.
Recently one of the sql table field have been changed from integer to decimal. Then the same function no longer work. When the patch function is triggered it returned:
Network error when using Patch function. The specific record was not found.
By using monitor to track. There is Not Found error on createRow operation:
{
"duration": 37.5,
"size": 54,
"status": 404,
"headers": {
"Content-Length": 54,
"Content-Type": "application/json",
"x-ms-client-request-id": "xxxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx"
},
"body": {
"statusCode": 404,
"message": "Resource not found"
},
"responseType": "text"
}
What is the problem?
