Power Platform Community Forum Thread Details

Hello,

I am trying to simply patch data to a table I have included in the dataverse that is connected to a simple PowerApp. Here is the output from the "CreateRow" response:

"duration": 2615.1,

"size": 1656,

"status": 400,

"headers": {

"REQ_ID": "fe6bb8a7-3df7-482d-82fc-4e6e45c3d86c",

"Content-Type": "application/json; odata.metadata=minimal",

"OData-Version": 4,

"Cache-Control": "no-cache",

"content-encoding": "gzip",

"Content-Length": 735,

"expires": -1,

"odata-version": 4,

"req_id": "fe6bb8a7-3df7-482d-82fc-4e6e45c3d86c",

"x-ms-client-request-id": "a68e4262-97a7-4750-af15-92d4ec5c891d"

"body": {

"error": {

"code": "0x80040224",

"message": "APIM request was not successful : StatusCode : BadGateway, Reason : OUTPUT is not supported., Response from APIM: {\r\n \"error\": {\r\n \"code\": 502,\r\n \"source\": \"msmanaged-na.azure-apim.net\",\r\n \"message\": \"BadGateway\",\r\n \"innerError\": {\r\n \"status\": 502,\r\n \"message\": \"OUTPUT is not supported.\\r\\nclientRequestId: eda6a5d2-ddfd-4cfc-bb91-6e278595e5c4-self\",\r\n \"error\": {\r\n \"message\": \"OUTPUT is not supported.\"\r\n },\r\n \"source\": \"sql-eus2.azconn-eus2-002.p.azurewebsites.net\"\r\n }\r\n }\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.ConnectorCreatePlugin]\r\n[de088602-7502-ee11-8f6e-000d3a338e52: External plug-in implementation]\r\n\r\n",

"@Microsoft.PowerApps.CDS.InnerError.Message": "APIM request was not successful : StatusCode : BadGateway, Reason : OUTPUT is not supported., Response from APIM: {\r\n \"error\": {\r\n \"code\": 502,\r\n \"source\": \"msmanaged-na.azure-apim.net\",\r\n \"message\": \"BadGateway\",\r\n \"innerError\": {\r\n \"status\": 502,\r\n \"message\": \"OUTPUT is not supported.\\r\\nclientRequestId: eda6a5d2-ddfd-4cfc-bb91-6e278595e5c4-self\",\r\n \"error\": {\r\n \"message\": \"OUTPUT is not supported.\"\r\n },\r\n \"source\": \"sql-eus2.azconn-eus2-002.p.azurewebsites.net\"\r\n }\r\n }\r\n}"

}

"responseType": "text"

Here is the patch command response from the terminal:

{

"status": null,

"duration": null,

"dataSource": null,

"responseSize": null,

"controlName": "Button1",

"propertyName": "OnSelect",

"nodeId": 20,

"formulaData": {

"script": "Patch(\r\n ProductionNotes__2_S,\r\n Defaults(ProductionNotes__2_S),\r\n {\r\n OrderNumber: 88888,\r\n Note1: \"Good times\",\r\n Company: \"ddd\",\r\n Completed: \"True\",\r\n DateCompleted: Now(),\r\n DateCreated: Now(),\r\n DateLastModified: Now(),\r\n Header4: \"top\",\r\n Note2: \"freda\",\r\n Note3: \"stuff\",\r\n Note4: \"things\"\r\n }\r\n)\r\n\r\n",

"spanStart": 0,

"spanEnd": 393

"data": {

"errorMessage": "Network error when using Patch function: The requested operation is invalid.",

"raiseToastNotification": false,

"wasReported": false,

"functionName": "Patch",

"context": {

"entityName": "Button1",

"propertyName": "OnSelect",

"id": 75,

"nodeId": 20,

"diagnosticContext": {

"span": {

"start": 0,

"end": 393

"formula": "Patch(\r\n ProductionNotes__2_S,\r\n Defaults(ProductionNotes__2_S),\r\n {\r\n OrderNumber: 88888,\r\n Note1: \"Good times\",\r\n Company: \"ddd\",\r\n Completed: \"True\",\r\n DateCompleted: Now(),\r\n DateCreated: Now(),\r\n DateLastModified: Now(),\r\n Header4: \"top\",\r\n Note2: \"freda\",\r\n Note3: \"stuff\",\r\n Note4: \"things\"\r\n }\r\n)\r\n\r\n"

}

"info": "Network error when using Patch function: The requested operation is invalid."

}

Can someone please help point me in the right direction on what I'm doing wrong?

Thank you

Categories:

Microsoft Dataverse with Power Apps