Unanswered

network error when using patch function the specified column is read-only and can't be modified

(0) Share

Report

Posted on by Baldeepsingh

I created a Simple sharepoint list named "Test" and it consist of 4 columns, Title, Requestor (Person type), Approval Status (Choice), Description (Multi line text) and i added some of the records.

Now i created a Power app and added a Gallery control that display the records from the SharePoint list and then added a Checkbox control to the Gallery for each record. For the Checkbox control I defined some of the properties:

OnCheck: Collect(varstatus,ThisItem)

OnUncheck: Remove(varstatus,ThisItem)

Default: ThisItem in varstatus

Then i added a Combobox control and for the Datasource property i set it to
Choices('Test List'.'Approval Status')

I also added a Button control and for the button control OnSelect property i set it to:

UpdateIf(varstatus,true,{'Approval Status':{Value:ComboBox1.Selected.Value}});
Patch('Test List',varstatus);
Clear(varstatus)

Now when i am playing the app and selecting two records from the gallery and selecting a Approval status from Combobox control and pressing the Button i am getting the error.

What am i doing wrong and why it shows me that Network error when using Patch function: the specified column is read-only and can't be modified

@power

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Matt555 8 on at

Like (0)

Report

When adding entering the SharePoint list into items field for the the gallery, try doing it like the below:

ShowColumns('Test List',"ID","Test Title","Requestor","Approval Status","Description")

Was this reply helpful? Yes No
Baldeepsingh on at

Like (0)

Report

I am the Owner of this list and still i am unable to update the item using UpdateIf and Patch function.

However if i am just using this formula on the Button OnSelect property:
UpdateIf(
varstatus,
true,
{ApprovalStatus:ComboBox1.Selected}
)

and then i am adding a new gallery and the Datasource of the gallery is connected to the Collection. I can see that in the second gallery the Status value is getting updated to the selected status but the second part of the function which is
Patch ( 'Test List', varstatus) //where varstatus is a collection
is not getting executed.

I also tried your way where i am restricting the SharePoint list items using ShowColumn function but it is giving me a new error which is "The requested operation is invalid"

Was this reply helpful? Yes No
Matt555 8 on at

Like (0)

Report

I've found that sometimes some of the embedded SharePoint columns like, Created By, can cause the error you mention. Try using ShoColumns to use only the columns you need from the SharePoint list plus the ID column, which is needed to update the record.

Was this reply helpful? Yes No