Hello,
I'm currently using a form element to add new rows into a SharepointList. However, I wanted some of the column options to be specified from an excel sheet which I successfully done using the Distinct function in their data field.
When I try submitting the form using SubmitForm, I get the following error:
{
"status": null,
"duration": null,
"dataSource": null,
"responseSize": null,
"controlName": "SubmitButton",
"propertyName": "OnSelect",
"nodeId": null,
"formulaData": {
"script": "SubmitForm(ClaimForm)",
"spanStart": null,
"spanEnd": null
},
"data": {
"errors": [
{
"Kind": 8,
"Message": "Network error when using Patch function: The requested operation is invalid.",
"Source": "SubmitButton.OnSelect",
"Observed": "SubmitButton.OnSelect",
"Details": {
"HttpStatusCode": 400,
"HttpResponse": {
"status": 400,
"message": "Object must implement IConvertible.\r\nclientRequestId: 8889aa15-810e-4dca-91bf-5e3e2671c5da\r\nserviceRequestId: 8889aa15-810e-4dca-91bf-5e3e2671c5da"
}
}
}
],
"info": "Network error when using Patch function: The requested operation is invalid.",
"context": {
"entityName": "SubmitButton",
"propertyName": "OnSelect",
"diagnosticContext": {
"formula": "SubmitForm(ClaimForm)"
}
}
}
}
My List column is set to test at the moment so it should allow the options specified in the combo box. I can't specify the options within the Column setting on the list as there's too many of them.