Unanswered

Feeding dropdown from selection in previous dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm working on a pretty simple app for work. It's attached to a SQL database and I have all the neceesary tables linked in.

I have one drop down that just has an item list in it for Truck or Driver. I'm trying to make the second drop down populate with a list of items depending on the selection of dropdown 1.

For example, if Dropdown 1 is set to Truck, I need to query table UnitList2 where column Active is Y and return the list from column Unit.

If Dropdown 1 is set to Driver, I need to query table DriverList where column Active is Y and return the list from column Driver_List.

Can anyone assist with how to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

I have not tested it but it should be something like this.

DropDown1.Item:
["Truck","Driver"]
DropDown2.Item:
If( DropDown1.Selected.Value = "Truck", ShowColumns(Filter(UnitList2,Active="Y"),Unit), DropDown1.Selected.Value = "Driver", ShowColumns(Filter(DriverList,Active="Y"),Driver_List) )

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

HI

Just my additional points though without your entity or table.

Option 1: change from IF to Swtich to make it simpler.
- Switch(Dropdown1.Selected.Value, "Truck", Results1, "Driver", Results2)
Switch is simpler than IF

Option2: Use Filter directly
Let say Dropdown1.Items = Distinct(Table1, FieldTitle1), where Field1 contains Truck, Driver,... or just ["Truck", "Driver", "..", ]
Then in Dropdown2.Items = Filter(Table2, FieldTitle2 = Dropdown1.Selected.Value).Results3

Hope this helps as well apart from @Anonymous's ideas.
TQ

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

Like
a
(0)

Report
Copy link

Link copied!

Thank guys for the input, sorry for the delay in responding, I never not any notifications that people had responded.

Our requirements have changed, do I only need the driver list, but I will play with this code in another app to see if I can get it working.

Was this reply helpful? Yes No