Power Platform Community Forum Thread Details

We created a Virtual Table within Dataverse, based on a SQL table. The table has multiple relationships with other tables, which can be optional (nullable uniqueidentifier).

When filling a uniqueidentifier relationship all works well, but we are unable to clear this value.

Trying this from within the table itself, we get an error message (1 row is not saved). The netwrok trace shows an error message on the PATCH call;

{
"error": {
"code": "0x80040224",
"message": "APIM request was not successful : StatusCode : BadRequest, Reason : Conversion failed when converting from a character string to uniqueidentifier., Response from APIM: {\r\n \"status\": 400,\r\n \"message\": \"Conversion failed when converting from a character string to uniqueidentifier.\\r\\nclientRequestId: 33f6433e-b449-4a79-a718-8adcbadb0c32-self\",\r\n \"error\": {\r\n \"message\": \"Conversion failed when converting from a character string to uniqueidentifier.\"\r\n },\r\n \"source\": \"\"\r\n}",
"@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040224&client=platform",
"@Microsoft.PowerApps.CDS.TraceText": "\r\n[Microsoft.Xrm.DataProvider.Connector.Plugins: Microsoft.Xrm.DataProvider.Connector.Plugins.ConnectorUpdatePlugin]\r\n[a91bfcfe-5bee-ee11-a1fe-00224888476f: External plug-in implementation]\r\n\r\n",
"@Microsoft.PowerApps.CDS.InnerError.Message": "APIM request was not successful : StatusCode : BadRequest, Reason : Conversion failed when converting from a character string to uniqueidentifier., Response from APIM: {\r\n \"status\": 400,\r\n \"message\": \"Conversion failed when converting from a character string to uniqueidentifier.\\r\\nclientRequestId: 33f6433e-b449-4a79-a718-8adcbadb0c32-self\",\r\n \"error\": {\r\n \"message\": \"Conversion failed when converting from a character string to uniqueidentifier.\"\r\n },\r\n \"source\": \"sql-we.azconn-we-002.p.azurewebsites.net\"\r\n}"
}
}

Trying this with Power Automate, we receive the same response with the following input