Answered

Auto-Populate fields based on other field value entered

(0) Share

Report

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

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like (4)

Report
Copy link

Link copied!

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

v-qiaqi@microsoft.com Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
David8 89 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
David8 89 on at

Like (0)

Report
Copy link

Link copied!

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'

Was this reply helpful? Yes No
misterjonih 85 on at

Like (0)

Report
Copy link

Link copied!

hi @v-qiaqi-msft
can I use Search function in multiple field?

Was this reply helpful? Yes No
Adwene 24 on at

Like (0)

Report
Copy link

Link copied!

Good day
Can you please assist me also

Was this reply helpful? Yes No
Adwene 24 on at

Like (0)

Report
Copy link

Link copied!

Good day
I'm new to Powerapps. Can you please assist me. I followed the GIF but can't seem to get it right.
I need the Employee name to be auto-populated based on Persal no entered. second screenshot is my SP list.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have a SharePoint list with StartDate and EndDate. WeekNumber. Based on the Todays date, I need to compare between Start and End Date and autopopulate the week number in my powerapps. For eg: StartDate : 2/27/2022 and EndDate: 3/5/2022, the WeekNumber is 1. I have totally 52 weeks. Need some pointers.

Was this reply helpful? Yes No
TKSHEP 212 on at

Like (0)

Report
Copy link

Link copied!

I am trying to auto populate the status field to Submitted to Supervisor, I am unable to find a var for the status filed in my sharepoint list. and the one Var that shows up does not work. Any suggestions or work arounds?
Thank you!

Was this reply helpful? Yes No