cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andreas_TR
Helper II
Helper II

Power App Drop Down Lookup Up auto populate

Hello 

 

i have a SharePoint list named List 1 that has a lookup column named Customers that takes data from another list (List2) and has the customer info (like address,payment,tax code..etc).I create a power app form with Customer as a drop down and i want to auto populate the other fields (address ,payment,code..) based on the customer selection.

Any ideas ?

thank you

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @andreas_TR ,

 

Customer Name, Address, Tax code are additional fields bound to Name Column, they only appear when Name Column is saved, even if in SharePoint. So I suggest you create some custom cards to show these additional fields.

 

The workaround:

1. Add a custom card in the form

2. Add two labels in custom card 

3. set Label1 Text property: Name: Customer Name

4. Set Label2 Text property: 

LookUp('List 2',ID=DataCardValue1.Selected.Id).'Customer Name'  // DataCardValue1 is the control Name of Name combo box.

 

Snipaste_2020-03-06_16-36-34.png

 

Sik

 

 

View solution in original post

9 REPLIES 9
eka24
Super User
Super User

Please which of the list is used as the items on the dropdown List1 or List2

Also is it Distinct on the dropdown?

@eka24  thank you for reply

 

its list1 that has the column customers .it s not distinct 

when i create new record i dont see the values of the other fields(tax code,Address..) when i select the customer

new_record.jpg

but if i save the record and re open it i see the values of the fields

saved.jpg

eka24
Super User
Super User

Try and follow these steps:

1. Insert a textbox1 and set it Default to: Dropdown1.Selected.Value using List1 (This picks the dropdown item)

2. In your DatacardValue for Address put:
                LookUp(List2,Customer=textbox1.Text,Address)
      For Payment DatacardValue:
               LookUp(List2,Customer=textbox1.Text,Payment)

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

@eka24  thank you for reply

 

i tried but its not working

i cant see the selected customer address or the other fields based on customer selection

Please can you show screenshot of what you did

@eka24  thank you

 

List 1

list1.jpg

 

list 2

list2.jpg

 

power app 

lookup.jpg

Hi @andreas_TR ,

 

Customer Name, Address, Tax code are additional fields bound to Name Column, they only appear when Name Column is saved, even if in SharePoint. So I suggest you create some custom cards to show these additional fields.

 

The workaround:

1. Add a custom card in the form

2. Add two labels in custom card 

3. set Label1 Text property: Name: Customer Name

4. Set Label2 Text property: 

LookUp('List 2',ID=DataCardValue1.Selected.Id).'Customer Name'  // DataCardValue1 is the control Name of Name combo box.

 

Snipaste_2020-03-06_16-36-34.png

 

Sik

 

 

View solution in original post

Have you got any more detailed instructions, I am trying to do this on my powerapp but I can't seem to get it to work?

 

Thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,573)