Getting: network error when using patch function : the specified column is read-only and can't be modified. When no column is on readonly

[fabianchavarria]

Hello everyone, I don't know if any of you've encounter with this problem saying, "network error when using patch function: the specified column is read-only and can't be modified". I'm not really sure why is happening because I don't have any read-only column and trying to "solve" that I unhide every column, but the problem persists, also on every second attempt of running the function it works fine.
I'm going to explain the process in any case anybody can help me:

I have a filtered gallery filtered by a choice column of status and ordered by other one called Checked:

Sort(
    Filter(
        'Inventario PowerApps PreProd', STATUS.Value = "Por asignar",
        StartsWith(Título, SerialSearchInventario_Input_1.Text) || IsBlank(SerialSearchInventario_Input_1.Text)
    ), Checked, SortOrder.Ascending
)

Every item in this gallery has a checkbox that on check does this:

Collect(colDataPorAsignar,ThisItem); UpdateIf('Inventario PowerApps PreProd', ID = ThisItem.ID, {Checked: true})

and uncheck the opposite

The problem comes when using a checkbox to check every item in the gallery, it works fine checking everything OnCheck: 

ClearCollect(colDataPorAsignar, Filter('Inventario PowerApps PreProd', STATUS.Value = "Por asignar"));
UpdateIf(colDataPorAsignar, true, {Checked: true});
Patch('Inventario PowerApps PreProd', colDataPorAsignar)

But when UnCheking the first time it shows the error, and in the second try it works fine

UpdateIf(colDataPorAsignar, true, { Checked: false }); // Update the Checked property
Patch('Inventario PowerApps PreProd', colDataPorAsignar); // Apply changes to your data source
Clear(colDataPorAsignar); // Clear the collection

Screenshot for reference:

[EddieE]

@fabianchavarria 

This maybe due to network slowness. When you Check the whole gallery and update the records, the data source may still be processing your changes so you cannot UnCheck until this is done - not sure, but this maybe the issue.

You could try adding a Refresh(datasource) to the end of your Check code to test this, eg

ClearCollect(colDataPorAsignar, Filter('Inventario PowerApps PreProd', STATUS.Value = "Por asignar"));
UpdateIf(colDataPorAsignar, true, {Checked: true});
Patch('Inventario PowerApps PreProd', colDataPorAsignar);
Refresh('Inventario PowerApps PreProd')

If this does solve the issue you could setup a Timer that runs OnCheck and on UnCheck that disables the checkbox for 1-2 seconds after being changed?

[fabianchavarria]

Try it, but sadly didn't work, maybe it has something to do with network slowness, I'm going to look more into it. thanks anyways for your time