Power Platform Community Forum Thread Details

I keep receiving this network error when testing the patch:

Also what does "Value function converted an empty text to a blank value" mean?

details that come up for "unhandled error":

{
  "status": null,
  "duration": null,
  "dataSource": null,
  "responseSize": null,
  "controlName": "Button_Submit",
  "propertyName": "OnSelect",
  "nodeId": null,
  "formulaData": {
    "script": "Navigate('Submitted screen');\r\nReset(Dropdown_Transport);\r\nReset(TextBox_Description);\r\nReset(Dropdown_Approvedby);\r\nReset(Dropdown_Checkedby);\r\nReset(TextBox_NightsAway);\r\nReset(Dropdown_TypeofExpense);\r\nReset(TextBox_Mileage);\r\nReset(TextBox_MileageTotal);\r\nReset(Dropdown_Paidby);\r\nReset(TextBox_EndTotal);\r\nReset(Dropdown_CostCentre);\r\nReset(Date_date);\r\nReset(Checkbox_Cash);\r\nReset(Checkbox_VISA);\r\nReset(Date_ExpIncWE);\r\nReset(Textbox_Expensetotal);\r\nReset(Checkbox_VAT);\r\n\r\nUpdateContext(\r\n    {\r\n        varID:\r\n        Patch(\r\n            'All data #3',\r\n            Defaults('All data #3'),\r\n            {\r\n                'Amount incl. VAT': Value(Textbox_Expensetotal.Value),\r\n                'Amount Excl. VAT': Value(Textbox_Expensetotal.Value) - (Value(Textbox_Expensetotal.Value)*20%),\r\n                'VAT (20%)': Value(Textbox_Expensetotal.Value) * 20%\r\n            }\r\n        ).ID\r\n    }\r\n);\r\nPatch('All data #3',\r\n{\r\n    ID: varID,\r\n    Description: TextBox_Description.Value,\r\n    Cash: {Value:Checkbox_Cash.Checked},\r\n    Employee:\r\n    {\r\n        Claims: Concatenate(\r\n        \"i:0#.f| membership|\",\r\n        User().Email),\r\n        Department: \"\",\r\n        DisplayName:User().FullName,\r\n        Email:User().Email,\r\n        JobTitle:\"\",\r\n        Picture:\"\"\r\n    },\r\n    Date:Date_date.SelectedDate,\r\n    Mileage: Value(TextBox_Mileage.Value),\r\n    'Mileage total':Value(TextBox_MileageTotal.Value),\r\n    'Nights Away':Value(TextBox_NightsAway.Value)\r\n}\r\n)\r\n",
  "spanStart": null,
    "spanEnd": null
  },
  "data": {
    "errors": [
      {
        "Kind": 23,
        "Message": "Network error when using Patch function: An error occurred on the server.",
        "Source": "Button_Submit.OnSelect",
        "Observed": "Button_Submit.OnSelect",
        "Details": {
          "HttpStatusCode": 502,
          "HttpResponse": {
            "error": {
              "code": 502,
              "source": "uk-001.azure-apim.net",
              "clientRequestId": "7b89214d-779b-476b-bc18-f6d972d3fc92",
              "message": "BadGateway",
              "innerError": {
                "status": 500,
                "message": "Argument is an invalid original issuer identifier.\r\nParameter name: encodedValue\r\nclientRequestId: 7b89214d-779b-476b-bc18-f6d972d3fc92\r\nserviceRequestId: 7b89214d-779b-476b-bc18-f6d972d3fc92"
              }
            }
          }
        }
      }
    ],
    "info": "Network error when using Patch function: An error occurred on the server.",
    "context": {
      "entityName": "Button_Submit",
      "propertyName": "OnSelect",
      "diagnosticContext": {
        "formula": "Navigate('Submitted screen');\r\nReset(Dropdown_Transport);\r\nReset(TextBox_Description);\r\nReset(Dropdown_Approvedby);\r\nReset(Dropdown_Checkedby);\r\nReset(TextBox_NightsAway);\r\nReset(Dropdown_TypeofExpense);\r\nReset(TextBox_Mileage);\r\nReset(TextBox_MileageTotal);\r\nReset(Dropdown_Paidby);\r\nReset(TextBox_EndTotal);\r\nReset(Dropdown_CostCentre);\r\nReset(Date_date);\r\nReset(Checkbox_Cash);\r\nReset(Checkbox_VISA);\r\nReset(Date_ExpIncWE);\r\nReset(Textbox_Expensetotal);\r\nReset(Checkbox_VAT);\r\n\r\nUpdateContext(\r\n    {\r\n        varID:\r\n        Patch(\r\n            'All data #3',\r\n            Defaults('All data #3'),\r\n            {\r\n                'Amount incl. VAT': Value(Textbox_Expensetotal.Value),\r\n                'Amount Excl. VAT': Value(Textbox_Expensetotal.Value) - (Value(Textbox_Expensetotal.Value)*20%),\r\n                'VAT (20%)': Value(Textbox_Expensetotal.Value) * 20%\r\n            }\r\n        ).ID\r\n    }\r\n);\r\nPatch('All data #3',\r\n{\r\n    ID: varID,\r\n    Description: TextBox_Description.Value,\r\n    Cash: {Value:Checkbox_Cash.Checked},\r\n    Employee:\r\n    {\r\n        Claims: Concatenate(\r\n        \"i:0#.f| membership|\",\r\n        User().Email),\r\n        Department: \"\",\r\n        DisplayName:User().FullName,\r\n        Email:User().Email,\r\n        JobTitle:\"\",\r\n        Picture:\"\"\r\n    },\r\n    Date:Date_date.SelectedDate,\r\n    Mileage: Value(TextBox_Mileage.Value),\r\n    'Mileage total':Value(TextBox_MileageTotal.Value),\r\n    'Nights Away':Value(TextBox_NightsAway.Value)\r\n}\r\n)\r\n"
     }
    }
  }
}

Formula:

Navigate('Submitted screen');
Reset(Dropdown_Transport);
Reset(TextBox_Description);
Reset(Dropdown_Approvedby);
Reset(Dropdown_Checkedby);
Reset(TextBox_NightsAway);
Reset(Dropdown_TypeofExpense);
Reset(TextBox_Mileage);
Reset(TextBox_MileageTotal);
Reset(Dropdown_Paidby);
Reset(TextBox_EndTotal);
Reset(Dropdown_CostCentre);
Reset(Date_date);
Reset(Checkbox_Cash);
Reset(Checkbox_VISA);
Reset(Date_ExpIncWE);
Reset(Textbox_Expensetotal);
Reset(Checkbox_VAT);

UpdateContext(
{
varID:
Patch(
'All data #3',
Defaults('All data #3'),
{
'Amount incl. VAT': Value(Textbox_Expensetotal.Value),
'Amount Excl. VAT': Value(Textbox_Expensetotal.Value) - (Value(Textbox_Expensetotal.Value)*20%),
'VAT (20%)': Value(Textbox_Expensetotal.Value) * 20%
}
).ID
}
);
Patch('All data #3',
{
ID: varID,
Description: TextBox_Description.Value,
Cash: {Value:Checkbox_Cash.Checked},
Employee:
{
Claims: Concatenate(
"i:0#.f| membership|",
User().Email),
Department: "",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
},
Date:Date_date.SelectedDate,
Mileage: Value(TextBox_Mileage.Value),
'Mileage total':Value(TextBox_MileageTotal.Value),
'Nights Away':Value(TextBox_NightsAway.Value)
}
)