Drop Down Menus

(0) Share

Report

Posted on by Sajarac

3,295

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

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

Was this reply helpful? Yes No
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No