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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Setting default value ...
Power Apps
Answered

Setting default value on a lookup field in canvas apps

(0) ShareShare
ReportReport
Posted on by

Hi,

I am new to Power Apps.  I wish to set a default value on a lookup field in canvas apps. I have a Dataverse table "Sales Planner" with a field "sales person" looking up to another Dataverse table "Sales Person Registry". 

In the canvas apps, I wish to set the default to "John Doe" if the form is new.

 

How should I do that?

 

Appreciate your advice.

Stephen

I have the same question (0)
  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Anonymous ,

     

    Have you tried something like the following?

    LookUp(SalesPersonRegistry, Name = "John Doe")
  • Community Power Platform Member Profile Picture
    on at

    Hi Drew

    Thanks for your help.  It is PERFECT!

     

    Stephen

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard