web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Lookup Column fo...
Power Apps
Unanswered

Patch Lookup Column for Dataverse

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    @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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard