Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
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

Categories:
  • Community Power Platform Member Profile Picture
    on at
    Re: Setting default value on a lookup field in canvas apps

    Hi Drew

    Thanks for your help.  It is PERFECT!

     

    Stephen

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Setting default value on a lookup field in canvas apps

    Hi @Anonymous ,

     

    Have you tried something like the following?

    LookUp(SalesPersonRegistry, Name = "John Doe")

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics