Patch function is returning error, "The specified column is read only"

(0) Share

Report

Posted on by johnjohnPter

2,098 Season of Giving Solutions 2025

I have this Patch function to update custom SharePoint fields, but i am getting this error:-

so all the field can be updated form sharepoint, so why i am getting this error?

Categories:

Building Power Apps

All responses (9)

Answers (3)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @johnjohnPter,

I was able to replicate the issue by trying to patch certain complex columns (choice & lookup) on authoring verion V3.23111.17. Would it be possible to navigate to your app settings (gear icon in the top header bar within the editor), select the Support tab and adjust the authoring version to the previous one. (in my case this is V3.23105.17) A visual guide to changing the Authoring version can be found here.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
johnjohnPter 2,098 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM i tried to adopt this version V3.23105.17, but i am still facing the same issue .. did it work for you?
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@johnjohnPter,

On my end it did fix the issue. As an additional change, would it be possible to slightly change the LookUp within your Patch:

Patch( ..., LookUp('Printing Orders Details' As Inner, Inner.ID = ID), ... )

I hope this helps!
johnjohnPter 2,098 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
@LaurensM Thanks a lot for your help. seems both reverting back to this version V3.23105.17,+ using As operator fixed the issue for me:-

Patch( 'Printing Orders Details', LookUp( 'Printing Orders Details' As i, i.ID = ThisRecord.ID ), { 'Network ID': ThisRecord.'Network ID', Quantity: ThisRecord.Quantity, 'Quantity Each Artwork': ThisRecord.'Quantity Each Artwork', 'Printing Order Type': {Value: ThisRecord.'Printing Order Type'.Value} } )

so regarding the version , when will this version V3.23105.17, get changed automatically ?
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @johnjohnPter,

In regards to the new version V3.23111.17 - the worldwide rollout date is on 07 Dec. according to the documentation:

I hope this helps!
johnjohnPter 2,098 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM so this mean on 7 December we might face the same issue of not been able to Patch complex sharepoint fileds? or Microsoft would fix this issue before making this worldwide?

second question, where i can post to Microsoft that this version V3.23111.17 has issues with patching complex types?
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohnPter since we dealt with 2 issues within this topic (Version & LookUp). Just to double check: Can you confirm that even after the LookUp change, the error still appears in V3.23111.17?
johnjohnPter 2,098 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM yes using the As inside this version V3.23111.17 will still show the error.. so the issue has 2 levels:-

1) not using the As
2) using this version V3.23111.17
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Ok thank you for confirming @johnjohnPter.

I will check with the forum admins on the best next steps & logging the issue. 😊 For now I will accept the answers to close the topic and allow other community members to more quickly find the solution should they have a similar issue.