On SharePoint 2016
I noticed a strange problem on a custom list that when I try to create an item in "Edit this list" mode on a list.
I get the error message in the browser is "Invalid Request"
I noticed the issue when trying to copy from excel into the list. But found that the issue occurs when typing an entry manually. I did find that I can add entries in 4 columns, but the 6th one seems to be causing the issue. I can also add multiple entries from Excel, I just can't populate the 6th column while in edit mode. However if I create an entry using Newform.aspx or edit the item after created using EditForm.aspx I can fill in the 6th field without an error.
I've tried saving the list with and without data as a template and tried redeploying, but the issue persisted on the new list.
I've tried manually recreating the custom list fields, and this did not resolve the issue either.
Tried converting test list columns to all be single lines of text, nor did this work.
Tried multiple browsers / computers no dice.
The fields in the list are below.
- Report ID (Calculated field)
- Module (Choice )
- Submodule (Choice )
- Report Number (Single line of text. This column is the renamed Title column)
- Report Title (Single line of text)
- Folder (Single line of text)
In Chrome's dev tools i did see the error message
"SchemaVersion":"15.0.0.0","LibraryVersion":"16.0.4756.1000","ErrorInfo":{
"ErrorMessage":"Invalid request.","ErrorValue":null,"TraceCorrelationId":"2c4a969f-64ff-b05c-e08d-91c76f7cc333","ErrorCode":-1,"ErrorTypeName":"Microsoft.SharePoint.Client.InvalidClientQueryException"
},"TraceCorrelationId":"2c4a969f-64ff-b05c-e08d-91c76f7cc333"
}
]
Then when looking for the correlation id with merge-splogfile I seen entries similar to below.
Original error: Microsoft.SharePoint.Client.InvalidClientQueryException: Invalid request.
at Microsoft.SharePoint.ServerStub.SPListItemServerStub.WriteOnePropertyValueAsJson(JsonWriter writer, Object target, ClientQueryProperty field, ProxyContext proxyContext)
at Microsoft.SharePoint.Client.ServerStub.WriteAsJson(JsonWriter writer, Object obj, ClientObjectQuery objectQuery, ProxyContext proxyContext)
at Microsoft.SharePoint.Client.ServerStub.WriteAsJsonWithMonitoredScope(JsonWriter writer, Object value, ClientObjectQuery objectQuery, ProxyContext proxyContext, MonitoredScopeType scopeType)
Any thought on how to allow me to use the list in edit mode would be appreciated.
Thanks in advance.