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.