Patch to a SharePoint Lookup Column

(0) Share

Report

Posted on by MarcBailey

230

I could really use some help on this one. Thanks, Marc

SharePoint Lookup Column does not update when executing the following Patch code from OnSelect of ListBox:

(The code does not show any errors.)

Patch(AcctMain,First(Filter(AcctMain,ID=CurrentAcctID)),{AcctStatus:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:Value(CurrentAcctID),Value:ListBox2_39.Selected.Value}})

AcctMain is SharePoint list that contains the Lookup column AcctStatus

CurrentAcctID is a global variable for the selected ID

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

MarcBailey 230 on at

Like
a
(1)

Report
Copy link

Link copied!

I think I have figured it out by switching from a ListBox to a Gallery. The ListBox did not provide for Id column. I was able to use the Gallery and include Id, Title, and DisplayName. Id and Title are required in the syntax and I needed DisplayName to properly display my Items. I made Visible: false for Id and Title.

If anyone has any different insight or suggestions - please post.

Thanks, Marc...

Was this reply helpful? Yes No
skmcken 320 on at

Like
a
(0)

Report
Copy link

Link copied!

You could still use the List Box but, you would would make use of a lookup reference as well: -

Patch(AcctMain,First(Filter(AcctMain,ID=CurrentAcctID)),{AcctStatus:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:Value(CurrentAcctID),Value:Lookup(DATASOURCE, StartsWith(ACCTStatus, ListBox2_39.Selected.Value).ID}})

Was this reply helpful? Yes No