We have a Power Automate flow which is to leverage the "Update record (V3)" connector to update the data in Business Central.
It worked well before the BC version update (ver 23.0).
However, after the BC version update to ver 24.0, the "Update record (V3)" connector keep failing with the following error.
We have verified that this is a BC version related issue (downgrade the BC to the previous version, the issue did not happen. Upgrade to 24.0 again, error starts to happen again.)
It seems to be a compatibility issue in the BC 24.0.
Does anyone have similar experience? Do you have a solution?
Please help.
Connector Outputs:
{
"statusCode": 500,
"headers": {
"Cache-Control": "no-cache",
"Pragma": "no-cache",
"Set-Cookie": "ARRAffinity=......;Path=/;HttpOnly;Secure;Domain=dynamicssmbsaas-scus....net,ARRAffinitySameSite=......;Path=/;HttpOnly;SameSite=None;Secure;Domain=dynamicssmbsaas-.......net",
"Strict-Transport-Security": "max-age=31536000",
"x-ms-request-id": "xxxxxx-xxxx-...",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 07 Jun 2024 05:51:56 GMT",
"Content-Length": "551",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": 500,
"source": "flow-apim-unitedstates-002-westus-01.azure-apim.net",
"clientRequestId": "......",
"message": "BadGateway",
"innerError": {
"status": 500,
"message": "Value cannot be null.\r\nParameter name: type\r\nclientRequestId: ......",
"error": {
"message": "Value cannot be null.\r\nParameter name: type"
},
"source": "dynamicssmbsaas-scus.azconn-scus-001.p.azurewebsites.net"
}
}
}
}
