Auto-Populate fields based on other field value entered

[akashsaraswat19]

Hello,

I am very new to Powerapps. I have a simple question,

I have already connected excel table to my app. So when a user wants to submit a new form, based on the item number entered by the user, the product name field must be automatically filled in. The excel data base contains all the Item Numbers and the respective product names.

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.

[v-qiaqi-msft · Accepted solution]

Hi@akashsaraswat19,

Based on the issue that you mentioned, I discovered that you have proposed a similar case which has been marked solved. Is there anything unsolved, could you please share more about your scenario?

We are used to using LookUp() when it comes to auto-populating one field based on another field filled. This function is easier and efficient.  

Since you mentioned that this autofill issue is related to submitting a new form, I think there is something different from the case you proposed before.

I have a test on my side, you can take a try as below.

Set the Default property of the data card belonging to product name as below

If(EditForm1.Mode=FormMode.New,LookUp(Employees,EmployeesId=DataCardValue3.Text,EmployeesName))​

On your side, you can write as below

If(EditForm1.Mode=FormMode.New,LookUp(Table1,ItemNumber=DataCardValue3.Text,ProductName))​

Note: DataCardValue3 represents by the control belonging to Item Numbers in your Form.

You can also check the GIF attachment for reference.

Best Regards,

Qi

[v-qiaqi-msft]

Hi@akashsaraswat19,

Have you solved your issue?

If it solves your request, Mark it as a Solution to enable other users to find it.

Best Regards,

Qi

[David8]

This is the solution I am looking for but I can't seem to make it work in my scenario. Here is a screenshot.

I want the number 1260 to come from a collection I created called ccCatalog. When I lookup the number, 1260, I want the name of the project field contained in the collection to appear. The data is saving to a SharePoint list.

Would appreciate some help. Thank you in advance.

[David8]

Right after I submitted my request, I figured it out. I'm placing the formula here in case it helps someone else.

LookUp(ccCatalog, 'ISSR Number' in TXAnalystISSR.Text ).'Project Name'