Answered

Power App Drop Down Lookup Up auto populate

(0) Share

Report

Posted on by AndreasTR

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

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please which of the list is used as the items on the dropdown List1 or List2
Also is it Distinct on the dropdown?

Was this reply helpful? Yes No
AndreasTR 90 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 thank you for reply

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

Was this reply helpful? Yes No
AndreasTR 90 on at

Like
a
(0)

Report
Copy link

Link copied!

when i create new record i dont see the values of the other fields(tax code,Address..) when i select the customer
but if i save the record and re open it i see the values of the fields

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

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AndreasTR 90 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

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

Like
a
(0)

Report
Copy link

Link copied!

Please can you show screenshot of what you did

Was this reply helpful? Yes No
AndreasTR 90 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 thank you

List 1

list 2

power app

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

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

Sik

Was this reply helpful? Yes No
alex2712 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No