Patch has suddenly stopped working for me.

[AmyF]

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.

[Abdul12 · Accepted solution]

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]

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!