Announcements
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
Hi @Anonymous ,
Have you tried something like the following?
LookUp(SalesPersonRegistry, Name = "John Doe")
Hi Drew
Thanks for your help. It is PERFECT!
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324