How to patch the lookup value?

(0) Share

Report

Posted on by Ganeshtamil_29

177

Kindly help to Patch the below lookup record.

Thanks in Advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

WarrenBelz 154,393 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Ganeshtamil_29 ,

The output of that (to Patch) is simply

executor1_1.Text

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Ganeshtamil_29 177 on at

Like (0)

Report
Copy link

Link copied!

HI @WarrenBelz
I already try this, but error shown.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Ganeshtamil_29

On the screen, the executor shows as text. But looks like executor as the person data type is in Sharepoint. is it correct?

If the executor is a person record then your patch command like
With({ItemExecutor:LookUp('IFeature Model Parameter', 'DIR Number'=dir_4.Text,Executor)}, Patch( SPDataSource, Defaults(SPDataSource), { Executor: { Claims: "i:0#.f|membership|" & ItemExecutor.Email, Department: "", DisplayName: ItemExecutor.DisplayName, Email: ItemExecutor.Email, JobTitle: "", Picture: "" } } ) )

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,694 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Ganeshtamil_29,

Please find my blog for Patching Lookup or Choice Field from PowerApps

https://microsoftcrmtechie.blogspot.com/2021/09/how-to-patch-choice-field-and-lookup-in.html

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Ganeshtamil_29 177 on at

Like (0)

Report
Copy link

Link copied!

Hi @rampprakash
Below error shown, kindly help to resolve

Was this reply helpful? Yes No
Ganeshtamil_29 177 on at

Like (0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy
Below error shown, kindly help to resolve

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @Ganeshtamil_29

Is the executor the Lookup field?

If it's a Lookup field then we need to find the ID using the DIR Number and use the syntax (id and Value)

With({ItemExecutor:LookUp('IFeature Model Parameter', 'DIR Number'=dir_4.Text)}, Patch( SPDataSource, Defaults(SPDataSource), { Executor: { Id: ItemExecutor.ID, Value: ItemExecutor.Title //Columnname that display the text } } ) )

Was this reply helpful? Yes No
Ganeshtamil_29 177 on at

Like (0)

Report
Copy link

Link copied!

Still error,

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Ganeshtamil_29 ,

@StalinPonnusamy is correct - you have the brackets around the wrong way

With({ItemExecutor:LookUp('IFeature Model Parameter', 'DIR Number'=dir_4.Text)},

Was this reply helpful? Yes No