Answered

Patch lookup column error: ID The specified column is specified by the server and can't be updated.

(0) Share

Report

Posted on by Rusty1

I have a one-column list called User. I use this as a lookup column on another list called Bookings that uses Title as the view field.

When I try and update the lookup column in Bookings from my powerapp I get an error saying ID: The specified column is specified by the server and can't be updated.

Patch(Bookings,Defaults(Bookings),LookUp(Bookings,ID = selectedID),
 {
 User: {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Id: 1,
 Value: "A Person"
 }
 }
)

I have confirmed that 'ID:1' and 'A Person' match in Users. I have searched google and no one seems to be having this problem so I must be missing something. Does anyone know what I'm missing? Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Rusty1

Take out Defaults(Bookings) from your formula. That is only used when you are adding a new item to the list.

Was this reply helpful? Yes No
Rusty1 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, done that, makes sense as to the error now. The reason I added that in the first place was because the previous error I had was 'Unknown Error Occurred, since removing Defaults(Bookings) it's gone back to that.

However, I made a new app and it works fine so no idea what happened. Thanks

EDIT: The Patch was being called by the OnClick of a button, I made a new button and copied the exact same code into it and it works.

Was this reply helpful? Yes No