web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Lookup Column fo...

Power Apps

Unanswered

Patch Lookup Column for Dataverse

(0) Share

Report

Report

Posted on by Minglee99

25

Hello everyone,

I am aware that in Canvas App to patch a lookup column in Dataverse we will usual do something like this:

Patch(Datasource, Default(datasource), ColumnSchemaName: Lookup(datasource, Name="ABC")).

but is it possible to do it like this instead?

Patch(Datasource, Default(datasource), ColumnSchemaName:{ IDColumn: "100", Value:"ABC"} )

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Minglee99

Hi, yes you can as long as you have the id
Patch(MySource, Defaults(MySource), { LookUpField: { Id: TheId, Value: Whatever Column that is the default like Name } } );

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No

Join the conversation