Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 41

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.

Categories:
  • Verified answer
    JCallan Profile Picture
    JCallan 41 on at
    Re: Network error when using Patch function: The specified column is read-only and can't be modified. -- only on some records using Form

    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.

  • JCallan Profile Picture
    JCallan 41 on at
    Re: Network error when using Patch function: The specified column is read-only and can't be modified. -- only on some records using Form

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard