Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 3oOOZ+3NYchF9cKGhvDH39
Power Apps - Building Power Apps
Answered

The specified column is read-only and can't be modified

Like (0) ShareShare
ReportReport
Posted on 22 Oct 2020 06:38:09 by 27

I am using a SharePoint integrated form and have collected the selected record in a collection.

I am then modifying this record inside the collection via form and Patch functions.

At the end I wanted to patch the changes back to the datasource via: 

- Patch(SharePointList,myCollection)

But I am countinuously getting the error: {VersionNumber}: The specified column is read-only and can't be modified...

I have tried to drop the version number via DropColumns function but then I get error for another field and another field and another field...

 

Please kindly support what is the issue... I think this should supposed to work since the columns in source and Collection are the same.. (i have a high number of columns though, around 70...)

  • SimCOB Profile Picture
    11 on 15 Nov 2023 at 01:44:01
    Re: The specified column is read-only and can't be modified

    Update: after I finished work, Microsoft Support got back to me and logged a defect in PowerApps that was later fixed. Surely I was'nt the only one experiencing this yesterday...

    Details:

    Problem
    When running a canvas app in the Studio or Player, you unexpectedly see an error "Network error when using Patch function: The specified column is read-only and can't be modified" when attempting to perform an operation that triggers a Patch request.

     

    Workaround
    The issue is a regression in the 3.23111.* and 3.23112.* authoring versions.
    Republish your app to the 3.23105.* version (or an earlier version) in the Power Apps Studio using the instructions
  • SimCOB Profile Picture
    11 on 14 Nov 2023 at 03:01:50
    Re: The specified column is read-only and can't be modified

    Hello ccuginotti,

    I'd tried something similar, but yours worked much better, and I got a column name! Thanks!


    Only problem is... it's telling me every single column name in the list (see attachment)

     

    These are not read only columns, they're columns I created myself as "Person" columns. I actually re-created the whole list an hour ago in case it was a list issue. There are 9 "person" columns, and 1 "lookup" column. This is to ensure I'm under the 12 maximum advanced fields (adding created by, modified by, gets to 12).

     

    Edit: Deleted all Person/Lookup except one, and it still errored. Then I realised it's happening to another list and another part of the app not updated in weeks. So I wonder if I've hit some kind of limit/restriction, or if there's a database issue in our region... logged with support. 

  • ccuginotti Profile Picture
    4 on 14 Nov 2023 at 02:15:52
    Re: The specified column is read-only and can't be modified

    Try adding 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(YourTableorList), 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.

     

    Credit: https://techcommunity.microsoft.com/t5/sharepoint/network-error-when-using-patch-function-the-specified-column-is/m-p/3720989

     

  • SimCOB Profile Picture
    11 on 14 Nov 2023 at 00:36:11
    Re: The specified column is read-only and can't be modified

    Signed in just to say YES! Agreed. WHICH COLUMN!!! Such a dumb error. Suddenly this morning all my app versions goes back days are giving this error, when the app worked fine yesterday. I have no idea what's happening or how I can fix it.

  • HEATFreight Profile Picture
    1,020 on 29 Jan 2023 at 18:59:22
    Re: The specified column is read-only and can't be modified

    This is a huge problem! Why isn't there a way to drop all read-only columns?

    How about this, Microsoft: if read-only columns always cause errors when patching data to SharePoint, wouldn't it be logical to always remove read-only columns from patch requests? Why should the user have to specify every single modifiable column with ShowColumns() or every single read-only column with DropColumns()????

    Isn't it obvious that the patch request should automatically drop all non-modifiable columns? What would be the harm in that? Don't give me an error! Just patch my data and make it work.

    This is such a major annoyance with developing canvas apps that talk to SharePoint, it just seems like the solution is glaringly obvious. Or how about this, TELL ME WHICH COLUMN IS READ-ONLY!!!!! The error message "Network error when using Patch function: The specified column is read-only and can't be modified." is frustratingly incomplete. Seriously, just tell me which columns I have to drop and I'll drop them. As it stands, I've gone down the entire list of auto-suggested columns and can't seem to find the remaining read-only columns. So, my next option would be to forget using DropColumns() and switch to ShowColumns() but that's an even worse solution because of how many columns are in this list. I should not have to explicitly specify every single modifiable column or every single read-only column in order to patch some data. This is ridiculous!

  • Lukas1 Profile Picture
    190 on 07 Feb 2022 at 12:34:09
    Re: The specified column is read-only and can't be modified

    @v-bofeng-msft is this still the only working solution in 2022? If all required fields need to be mentioned in the formula it's hard to maintain it.

  • Verified answer
    v-bofeng-msft Profile Picture
    on 22 Oct 2020 at 08:35:57
    Re: The specified column is read-only and can't be modified

    Hi @Student2 :

    Could you show me the data structure of myCollection

    Firstly,let me explain why you encounted this problem.

    The point is {VersionNumber} is a standard read-only field in the sharepoint list. There are many such fields, such as:ID,Modified,Created……

    Secondly,I suggest you filter out the required fields to update.

    For example:

    Patch(SharePointList,ShowColumns(myCollection,"Column1","Column2","Column3"))

    Or 

    ForAll(
     mycollection
     Patch(SharePointList,Defaults(SharePointList),{Column1:Column1,Column2:Column2})
    )

    Best Regards,

    Bof

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 32

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 19 Super User 2025 Season 1

#3
Rajkumar_M Profile Picture

Rajkumar_M 16 Super User 2025 Season 1

Overall leaderboard
Loading started