cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JCallan
Frequent Visitor

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

We have a Power App canvas app that uses a form for item Adds & Edits (same form, different mode).  Users are encountering the error when saving via SubmitForm(<formname>), but only on some records, about 4 out of ~4000 so far.  Once encountered, the item will not save any changes, which leads us to believe it is not a random connectivity issue. As it appears only related to specific records, we've reviewed those items to ensure no bad/invalid data exists in a complex or non-text data type column and found no oddities.  If we were writing out a read-only field on the form, we expect every record would have this issue. The form does display (read-only) some additional lookup field data, but that have been there since inception and never led to any for save issues.  To date: 

 

  • I have read all available posts concerning this error and reviewed those solutions to no avail
  • Refreshed the data source
  • Reconnected the data source
  • Deleted and re-added datacards for any newly added form fields (these were existing fields in the data source with one exception, which was a new field) and many of the date and choice fields.

The error does not indicate WHICH field is read-only.  My next attempt is to recreate the form in another app and see if those particular records will save.

 

Open to any thoughts or suggestions as the error message is not all that helpful.

1 ACCEPTED SOLUTION

Accepted Solutions

RESOLVED:  The issue was users entering invalid lookup values for a particular field.  The App was letting them create items with an invalid value, but prevented those items from saving on edit.  The fix was to add the needed values to the lookup list and then update the missing value in the item.  Both were required to get by the Network Error.  We had modified this particular datacards input field from a ComboBox to text input which made this possible.

View solution in original post

2 REPLIES 2
JCallan
Frequent Visitor

Data source for the above is SharePoint Online.  The source and form are quite large (150+ columns).  App has been in use for 9 months.  Problem occurred only recently.

RESOLVED:  The issue was users entering invalid lookup values for a particular field.  The App was letting them create items with an invalid value, but prevented those items from saving on edit.  The fix was to add the needed values to the lookup list and then update the missing value in the item.  Both were required to get by the Network Error.  We had modified this particular datacards input field from a ComboBox to text input which made this possible.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,158)