Answered

Autopopulate text input fields based on value/input in other text input

(0) Share

Report

Posted on by TC-02100712-0

Hi there,

we are a small team looking to build a reporting tool for our team.

I'm relatively new to powerapps and was hoping someone could help with a question:

We have this data

Employee id	Name	VHC	Shift	Time
15888	Thomas Crown	6057	14H81	05:45-13:37

Is it at all possible to create an app in which there is a text input for the employee id and then text inputs for the rest of the data, Name, VHC, Shift and Time and have these autopopulated based on the data entered in Employee id.

Categories:

Employee Ideas app on Teams

Connectors

Dataflows

Connecting to Data

I have the same question (0)

All responses (5)

Answers (3)

TC-02100712-0 13 on at

Like (0)

Report
Autopopulate text input fields based on value/input in other text input

Thank you very much for the answer :)

I ended up using the lookup function like so

LookUp(Employees;Employeeid=Value(Search.Text)).Name)
And then setting a variable to the search button like so:

UpdateContext({IsLocked: !IsLocked})

And then combining these in the text fields like so:
If(IsLocked;LookUp(Employees;Employeeid=Value(Search.Text)).Name)

This works super :)

Thanks guys

Was this reply helpful? Yes No
Verified answer

WarrenBelz 150,769 Most Valuable Professional on at

Like (1)

Report
Autopopulate text input fields based on value/input in other text input

Hi @TC-02100712-0,

The Default of those controls would be (change the last field name each time - also assuming a Modern Text Input)
Filter( ExcelTableName, 'Employee id' = YourTextInput.Value ).Name

Ths assumes 'Employee id' is a Text field - if it is a Number you need Value(YourTextInput.Value)

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 3,884 Super User 2025 Season 2 on at

Like (1)

Report
Autopopulate text input fields based on value/input in other text input

@TC-02100712-0,

Lets assume you store your data in a SharePoint list, Excel file in OneDrive, or Dataverse table.
Columns:

EmployeeID

Name

VHC

Shift

Time.

Create a Canvas App

Open Power Apps Studio.

Choose Canvas App → Phone layout or Tablet layout.

Connect to Your Data Source

Go to Data → Add data → Connect to your respective datasource (backend).

Add Controls to the Screen

Add a Text Input control for Employee ID (txtEmployeeID) / relevant controls as per your design logics.

Add Text Inputs or Labels for Name, VHC, Shift, and Time

Use the LookUp() function to find the record based on Employee ID.

Syntax

Lookup(Datasource, Condition).Column Name

For example, in the Default property of the Name field:

LookUp(EmployeeData, EmployeeID = Value(txtEmployeeID.Text)).Name

Extend the functionality for other fields

LookUp(EmployeeData, EmployeeID = Value(txtEmployeeID.Text)).VHC

LookUp(EmployeeData, EmployeeID = Value(txtEmployeeID.Text)).Shift

LookUp(EmployeeData, EmployeeID = Value(txtEmployeeID.Text)).Time

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

1 people found this reply helpful.

Was this reply helpful? Yes No
TC-02100712-0 13 on at

Like (0)

Report

Autopopulate text input fields based on value/input in other text input

@WarrenBelz

i'll try and structure it a bit more :)

I have pasted the screen below, and made the connection to my Excel Data, i want to then make a condition so that when i enter a Employee ID in the search bar and press search, if this employee id is correct, to then autopopulate the rest of the inputs with the related data in the related row.

So for example, Employee ID search for 15888 and then for it to autopopulate the inputs with, Thomas Crown, 6057, 14H81 and 05:45-13:37.

Hope this makes it more understandable :)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 150,769 Most Valuable Professional on at

Like (1)

Report

Autopopulate text input fields based on value/input in other text input

Hi @TC-02100712-0,

Yes, certainly possible if the 'Employee id' is unique - just need to lookup your reference list. Not sure how to elaborate further without more structure posted.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No