Auto Populate fields

[akashsaraswat19]

Hello everyone,

I am very new to Powerapps, I am creating a form and I have to do following things in the form:

1) If a Item Number is entered, then the product name must be automatically filled in. The Database containing the Item Number and Product name is an Excel File and I have already connected it to my App. 

Looking forward for your support.

[eka24 · Accepted solution]

You will have to use a lookUp. Assuming Table1 is the Excel Table with ID and ProductName as columns.

If the user Input ID into Textbox1, then in Default of TextBox2, put:

LookUp(Table1, ID=Value(Textbox1.Text),ProductName )

Or

LookUp(Table1, ID=Textbox1.Text,ProductName )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[akashsaraswat19 · Accepted solution]

@eka24Thank you it works perfect. 🙂

[eka24]

Kindly mark my reply as the solution

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.