web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How do I patch a recor...

Power Apps

Answered

How do I patch a record in another SP list

(0) Share

Report

Report

Posted on by jbacacia

3

I built a form in power apps but need to lookup and patch a record in a different SP list.

Right now I am trying to Patch('OtherList', Lookup('OtherList', CompanyName = Datacardvalue2.Selected), {Status: DataCardValue1.Selected, '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

But it isnt working.

Datacardvalue2 is a SP lookup field for 'OtherList' CompanyName so that my users can only add records to this new SP list based on companies already in 'OtherList'

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jbacacia ,

Strangely this is less complex than you think as you have the ID and the Value of the item already in the Lookup column (and the "other side" is not a Lookup - it is simply a field value)

Patch( 'OtherList', {ID:DatacardValue2.Selected.ID}, {Status: DataCardValue1.Selected.Value} )

PS Lookup fields are still a bad and unnecessary idea for Power Apps interfaces . . .

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation