cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Auto-Populate fields based on other field value entered

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.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

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.

View solution in original post

Community Support
Community Support

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.0004.gif

 

Best Regards,

Qi

View solution in original post

5 REPLIES 5
Super User III
Super User III

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.

View solution in original post

Community Support
Community Support

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.0004.gif

 

Best Regards,

Qi

View solution in original post

Community Support
Community Support

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

Frequent Visitor

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

 

David8_0-1612743275109.png

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.

 

Frequent Visitor

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'

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (79,631)