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 (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 (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