Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

How to auto populate fields in power apps using a dropdown

Hi All 


I have an Employees table in SQL as my data source  .

On a form I have a dropdown field called Employee number  or by just typing the employee number in that field(free text)  I want it to auto populate 3 fields for me. The users don't want type because it will be time consuming .How can I achieve this please?

 The Name 

 The Surname 

 The Branch 

Autopopulate  in power apps.JPG



Super User
Super User

Hi @rmaziwis 

What you are looking for is something called a "Type Ahead" dropdown control.  They are found in MS Access but not in PowerApps.  I missed them so I tried to create one.  Take a look here:  .  Since dropdown controls reference an entire record but only show one value in the window, you can set the Default properties of your text boxes to Dropdown1.Selected.Name and Dropdown.Selected.Surname respectively.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,378)