cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

AutoFill an input field

Hi All,

 

New to Power Apps and wanted to ask for help regarding a feature that i wanted to include on a form.

 

I have a sharepoint list that tracks transactions done by employee (EmployeeTransaction List).

And another list for Employee Details.

 

I followed along the tutorials and i thought i was confident enough to build an app on my own.

the feature that i cant figure out is when. 

 

The employee enters on the badge number field. the employee name should fill in with the name of the said employee based on the Badge Number.

 

Ive tried the LookUp formula.

 

LookUp('EmployeeList',Title_Column1.Text = Badge,Name)

 

Title_Column1.Text is the value of the badge number on the image below

ohraytyroo-1_0-1605821730972.png

But nothing happens. 

 

I have the display mode of the employee name as disabled so that it cant be edited.

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @ohraytyroo-1 ,

You need to refer to the control on the form, so

LookUp(
   'EmployeeList',
   Badge=YourBadgeNmuberBoxName.Text
).Name

should get you the value you need (assuming you field/list names are correct). On the OnChange of the Badge Number text box, reset the other one

Reset(YourNameTextBox)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Hi @ohraytyroo-1 ,

You need to refer to the control on the form, so

LookUp(
   'EmployeeList',
   Badge=YourBadgeNmuberBoxName.Text
).Name

should get you the value you need (assuming you field/list names are correct). On the OnChange of the Badge Number text box, reset the other one

Reset(YourNameTextBox)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Highlighted

Hi @WarrenBelz 

 

i tried it and it worked!!

 

Thank you!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,481)