Hi all,
I am getting a "specified column is read only" network error when trying to patch a collection to a sharepoint list in the following scenario.
When the start screen first becomes visible the app collects a complete copy of a sharepoint list into a collection. I use the standard code in the OnVisible property of the start screen: ClearCollect(colGridData,'SP List'). This works fine.
I have a gallery whose items are pulled from the collection. The user can edit a few columns from the collection (all text columns, none are system generated read only, and none are required to be populated). Those changes are then patched to the collection. This also works fine - all changes are properly reflected in the gallery after this patch.
When the user is done making changes, and the collection reflects those changes, I want to update the sharepoint list by patching the whole collection back to the list using this code in the OnSelect property of a button: Patch('SP List', colGridData). This is when it throws the network error about read only columns.
There are several articles and youtube vids that show this as possible, since the schema of the whole collection is identical to the sharepoint list. Oddly enough, in my troublehooting tests, sometimes it will successfully patch the collection to the list, but only the first time I do it. Any further attempts to patch throws the error. In other tests after closing and reopening the app, it won't even work the first time despite making the same test edits.
I don't want to have to manually code all the columns I'd like to patch (too many), so I thought I'd ask if anyone has any thoughts on what's causing this?
Thanks in advance
