Patch in SharePoint with a lookup to another list

(0) Share

Report

Posted on by pmwhelan

377

I have two lists in SharePoint

Firms and Requests.

I have a column in Requests (called Firm) that is a lookup to Title in Firms.

I have a gallery galFirms and when an item is selected it changes the DropDownList ddSelectedFirm

How can I Patch to add a record to Requests

This gives me an error "Some invalid arguments" ....

Patch(Requests, Defaults(Requests), {Firm: ddSelectedFirm.Selected )

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@pmwhelan patching a LookUp field to SharePoint works a little bit different.
Could you check if this written tutorial solves your problem?

That patch syntax should populate the LookUp field.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,764 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @pmwhelan ,

Firstly Lookup columns will cause you a bit more grief than this - you might consider their use unless really necessary, but to your issue. As the code does not work I have to assume that the Items of ddFirm are not simply

Choices(Requests.Firm)

so you need to "get back" the Id of the field which is actually the ID of the record in Firms matching the Title you looked up. What you will have is something like (NOTE Selected.Firm may be different depending on the Items of the drop-down)

Patch( Requests, Defaults(Requests), { Firm: { Value: ddSelectedFirm.Selected.Firm Id: LookUp( Firms, Title = ddSelectedFirm.Selected.Firm ).ID } } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks

So should it be ...

Patch(Requests, Defaults(Requests), {Firm: Property:{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:1,
Value:""
} )

That gives an error "Name isn't valid. Property isn't recognised"

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @pmwhelan,

I see that @WarrenBelz has nicely written out the syntax and value logic for your case.
Could you try that solution?

Was this reply helpful? Yes No