cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Drop Down Menus

Hello there, I am going mentyal with this, it seems like is easy but I cannot figure out.

 

I have my app with my fields and I would like once the user is in the EditScreen1 be able to choose a customer from a customer list, which is another table in a separate sheet in my excel file.

 

That table are tweo columns:

1. DropES and 2. CategoryID

 

What I want to do is:

 

1. The user can choose in the DropDown list a "DropES" Item.

 

2. I have a field in the same form "CategoryID" I would like once the user select a customer that field automatically gets populate with the Category ID text.

 

i.e Customer choose in the dropdownbox = Customer ABC "Row4", then the Category field label show = "C3"

 

Can someone help me with this?

 

Thanks in advance

 

BTW I have been trying VLoopkup without success

 

Regards

Choose.JPGDropDown.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Champion
Community Champion

Hi

 

For Dropdown, it is correct to use Distinct (DS, Field), because you need a TABLE.

But for your C3 (example), it is a RECORD.

So, you need to use LookUp.

e.g.:

LookUp(DS, Dropdown1.Selected.Result = DropEs).CategoryID

 

Hope this helps.

hpkeong

View solution in original post

4 REPLIES 4
New Member

Would something of this nature help?

 

Customer Dropbox Items

Distinct(Table,DropES)

 

Category Dropbox Items:

Distinct(Filter(Table, Customer_DropBox.Selected.Value exactin DropES).CategoryId, CategoryId)
Kudo Kingpin
Kudo Kingpin

Thank you very much for your prompt reply, I was able to do the first part, but for the second part I am getting an error, invalid name.

 

Sorry again, could you please let me know what I am doing wrong?

 

Capture2.JPG

Community Champion
Community Champion

Hi

 

For Dropdown, it is correct to use Distinct (DS, Field), because you need a TABLE.

But for your C3 (example), it is a RECORD.

So, you need to use LookUp.

e.g.:

LookUp(DS, Dropdown1.Selected.Result = DropEs).CategoryID

 

Hope this helps.

hpkeong

View solution in original post

Thank you very much for your response, however I can't have this working. 

 

Could you please let me know what is the issue?

 

Thanks in advance for your response

 

Drop.JPG

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.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (89,200)