web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch has suddenly sto...
Power Apps
Answered

Patch has suddenly stopped working for me.

(0) ShareShare
ReportReport
Posted on by 235

Hello,

I've been trying to implement Reza Dorrani's "Editable Grid in PowerApps | SharePoint List"  the youTube video.  

So after having several false starts I was able to get it working certainly for editing, I was able at one point to add several new records as well.  I put two editable grids in the same app and the second one was working well too, I got it to add data, didn't try new records on that one.  Then suddenly it stopped patching to the list.  I got a network error that the column was read-only and can't be modified.     I didn't understand why not.  It was only updating a comboBox, like it had before.  I checked out every property on that field.  So, ok that didn't work for some weird reason.  I switched fields I was updating, and I was able to edit and save each field on its own but if I tried it again, I'd get the message ever after on that field.  I cleared cache, I made a list from that list, put in data by hand, tried to edit and same error.  I switched to an older datasource that had been made from the original days before this started happening.  Now it's happening on that datasource too.  I pared down the app, removed the other grid (which had begun failing as well with the same error.

 

Something I notice and is still happening is sometimes when I exit a field, it triggers a patch to the collection, but it takes a very long time and I can see the little dots going across the screen and sometimes tell from looking at the fields that SOMETHING is going on.  I didn't think that Patch was supposed to do that.  I didn't do anything to tell it to only patch records that have changed or anything (because I don't know how to do that yet)

ALSO when this was working and writing to the original list, even though I only changed one record, that patch as well iterated through the entire list because all the modified dates had changed to minutes ago.

 

I removed the logic to create new records because it mentions "ID" otherwise there is no mention of ID in my app (yet), and beyond that the only field on the list that's required is Title.

 

I'm lost.  Thanks in advance for any kind of help.

Categories:
I have the same question (0)
  • Verified answer
    Abdul12 Profile Picture
    124 on at

    There are a few things that could be causing the "read-only" errors when trying to submit changes from the editable gallery:

    • Check the permissions on the SharePoint list - make sure the user has edit permissions and not just read.
    • Verify the columns allow editing - some column types like lookups may be read-only. Check the list settings.
    • Avoid patching the entire gallery dataset on each change - this can cause concurrency issues. Instead patch only the modified record.

    Adding new records requires providing a unique ID value - this could be triggering errors.

    • Limit PATCH calls to only when SubmitChanges is pressed, not on every change
  • AmyF Profile Picture
    235 on at

    I'm marking this as the solution.  Thank you.    I had to drop the column again and this time I was able to get it working.  I don't know what the problem was, but I feel that it was on my end (in fact, I'm sure of it)  Thanks again and sorry my response is so late.  Cheers!

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard