Unanswered

Auto Populate fields

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

eka24 20,923 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

akashsaraswat19 27 on at

Like (0)

Report

@eka24Thank you it works perfect. 🙂

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No