Network error when using Patch function: The specified column is read-only and can't be modified.

New Contributor

Hi All,

I've created a custom form to enter and edit data in a SharePoint Online List. 

Creating a new item works perfectly, but if I try to edit an existing item, I get the above error when I try to save, and all my changes are lost. 

 

Greg_from_Pond_0-1674221212313.png

I cannot see any "read only" fields (e.g. ID, Modified by, etc.) in the form in PowerApps. 

The "App Checker" in PowerApps does not detect any problems. 

Can anyone point me in the right direction? Even if it's just to some log files which might tell me which field/column is causing the problem?

Any suggestions appreciated. 

Greg. 

 

2 Replies

I managed to solve it myself.

I added the following code to the "on Error" field on the App (Select App from the Tree view on the left, then On Error from the properties on the right.)

 

Notify(
         Concat(Errors(ClientList), Column&": "&Message),
         NotificationType.Error
     )

 

It then told me what the offending column was next time the error occurred.

Hope this helps someone else in the future.

This worked for me. It didn't show the error right away in the screen with the issue. I had to go to another screen. Not sure what I did differently, but it did show the error as mentioned. Thank you!