web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps AutoFill an input field

Power Apps

Unanswered

AutoFill an input field

(0) Share

Report

Report

Posted on by Community Power Pla...

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

But nothing happens.

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

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

i tried it and it worked!!

Thank you!!

Was this reply helpful? Yes No

Join the conversation