Network Error - createRow - Bad Request - Error 400 (Network error when using path function: The requested operation is invalid)

[Previsible]

I am working on building an app that would take data from a set number of inputs (similar to a form) and then append those inputs to a Sharepoint List. 

I got it running and working yesterday, and then I saved everything and published it. But when I went to use the app I got the error: "Bad Request - Error 400 (Network error when using patch function: The requested operation is invalid)"

Set(varShowSpinner, true);
//update the count in the sharepoint list for tracking inventory
Patch('OCC Asset Checkout', varRecord2, {NumberOnLoan: varRecord2.NumberOnLoan + Form_Dropdown.Selected.Value});
//update the list of who has borrowed what
Patch('OCC Equipment List Log', Defaults('OCC Equipment List Log'), {Title: User().FullName, QTYBorrowed: Form_Dropdown.Selected.Value, DateBorrowed:Today(), DatePlannedReturn: Form_ReturnDate.SelectedDate, Status: "Borrowing", ItemBorrowed: varRecord2.ID, ItemBorrowedTitle: varRecord2.Title, User: Form_User, AssetID: Form_AssetID}); 

 

The error doesn't appear until I use the app for the first time, and I'm not sure where I'm going wrong on this

[jrletner]

Hi @Previsible, 

The only thing I can think of is maybe check your data types. You might be trying to set a value in the "OCC Equipment List Log" that is the incorrect type? 

If you check that and everything is ok, in your monitor, when you click on one of the lines, does it give you detailed information about what was sent and what was received back? Might be some information in that detail that could be helpful. 

[Previsible]

Thank you so much for your response

I confirmed all of the data types were what they were supposed to be

 

Then I deleted and recreated the button and arranged the variables in order as to how they appear on SharePoint to double-check

Patch(
    'OCC Equipment List Log',
     Defaults('OCC Equipment List Log'), 
     {
            Title: User().FullName, 
            User: Form_User, 
            AssetID: Form_AssetID, 
            QTYBorrowed: Form_Dropdown.Selected.Value, 
            DateBorrowed:Today(), 
            DatePlannedReturn: Form_ReturnDate.SelectedDate, 
            Status: "Borrowing", 
            ItemBorrowed: varRecord2.ID, 
            ItemBorrowedTitle: varRecord2.Title
    }
); 

I got the same error, so I opened the logs and clicked through:

{
  "status": null,
  "duration": null,
  "dataSource": null,
  "responseSize": null,
  "controlName": "Button1",
  "propertyName": "OnSelect",
  "nodeId": null,
  "formulaData": {
    "script": "Set(varShowSpinner, true);\r\n//update the count in the sharepoint list for tracking inventory\r\nPatch('OCC Asset Checkout', varRecord2, {NumberOnLoan: varRecord2.NumberOnLoan + Form_Dropdown.Selected.Value});\r\n//update the list of who has borred what\r\nPatch('OCC Equipment List Log', Defaults('OCC Equipment List Log'), {Title: User().FullName, User: Form_User, AssetID: Form_AssetID, QTYBorrowed: Form_Dropdown.Selected.Value, DateBorrowed:Today(), DatePlannedReturn: Form_ReturnDate.SelectedDate, Status: \"Borrowing\", ItemBorrowed: varRecord2.ID, ItemBorrowedTitle: varRecord2.Title}); ",
    "spanStart": null,
    "spanEnd": null
  },
  "data": {
    "errors": [
      {
        "Kind": 8,
        "Message": "Network error when using Patch function: The requested operation is invalid.",
        "Source": "Button1.OnSelect",
        "Observed": "Button1.OnSelect",
        "Details": {
          "HttpStatusCode": 400,
          "HttpResponse": {
            "status": 400,
            "message": "Object must implement IConvertible.\r\nclientRequestId: d2531805-133f-454b-8764-2a5b67ada667\r\nserviceRequestId: d2531805-133f-454b-8764-2a5b67ada667"
          }
        }
      }
    ],
    "info": "Network error when using Patch function: The requested operation is invalid.",
    "context": {
      "entityName": "Button1",
      "propertyName": "OnSelect",
      "diagnosticContext": {
        "formula": "Set(varShowSpinner, true);\r\n//update the count in the sharepoint list for tracking inventory\r\nPatch('OCC Asset Checkout', varRecord2, {NumberOnLoan: varRecord2.NumberOnLoan + Form_Dropdown.Selected.Value});\r\n//update the list of who has borred what\r\nPatch('OCC Equipment List Log', Defaults('OCC Equipment List Log'), {Title: User().FullName, User: Form_User, AssetID: Form_AssetID, QTYBorrowed: Form_Dropdown.Selected.Value, DateBorrowed:Today(), DatePlannedReturn: Form_ReturnDate.SelectedDate, Status: \"Borrowing\", ItemBorrowed: varRecord2.ID, ItemBorrowedTitle: varRecord2.Title}); "
      }
    }
  }
}

I see this:

"message": "Object must implement IConvertible.\r\nclientRequestId: d2531805-133f-454b-8764-2a5b67ada667\r\nserviceRequestId: d2531805-133f-454b-8764-2a5b67ada667"

 I looked this up and someone said it could be data source-related so I removed the Data source and re-added it but this didn't work. So I deleted the data source, deleted the list, recreated the list, added the data source and the error is still the same. 

[Previsible · Accepted solution]

I actually figured it out via another post as I was sleuthing, apparently for the text fields I need to add .Text like so:

Patch(
    'OCC Equipment List Log',
     Defaults('OCC Equipment List Log'), 
     {
            Title: User().FullName, 
            User: Form_User.Text, 
            AssetID: Form_AssetID.Text,
            QTYBorrowed: Form_Dropdown.Selected.Value, 
            DateBorrowed:Today(), 
            DatePlannedReturn: Form_ReturnDate.SelectedDate, 
            Status: "Borrowing", 
            ItemBorrowed: varRecord2.ID, 
            ItemBorrowedTitle: varRecord2.Title
    }
);

 It works now, thanks so much for your help I actually wouldn't have found this answer if you hadn't pointed out that I can click the Monitor Entry for more information!

[jrletner]

Good catch. So the data type you were passing was the actual control. Adding the .text sent a string data type instead!