Answered

Dependent Drop downs

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Trying to set up a dropdown that will hide items that were selected in another column. Show items as long as they don't exist in that column anymore. Thanks!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Something like this?

Filter( "Whatever your Default property is for Dropdown 2", Not(Value in Dropdown1.SelectedItems) )

I'd need to know more details of your two dropdowns and their types etc to give a more clear answer
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

need more info, but just a stab in the dark not knowing the data structure, id have a column of data pulled from a collection, clicking an item there adds it to another collection, and then make my dropdown give me the original collection, but filtered for only items Not in collection 2
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Dropdown1 Items:
If(DataCardValue33.Selected.Value = "A", [ "A1", "A2", "A3", "A4", "A5", "A6" ], DataCardValue33.Selected.Value = "B", [ "B1", "B2", "B3", "B4", "B5", "B6" ],
DataCardValue33.Selected.Value = "D", [ "D1", "D2", "D3", "D4", "D5", "D6" ], DataCardValue33.Selected.Value = "H", [ "H1", "H2", "H3", "H4", "H5", "H6" ])

The chosen value from Dropdown 1 will be the the parent value of a column called : RACK LOCATION

* I would like Dropdown1 to show only items that are not already assigned in Rack_Location column.

Much appreciated!
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Simple Example

My Dropdown list for exampl,e has an items property of

Filter(["A1","A2","A3","A4","A5","A6"], Not(Value in Test))

and an onchange of

Collect(Test,Self.Selected.Value)

Put a gallery below with items of

Test

and those items have an onselect of

RemoveIf(Test,Value=ThisItem.Value)

any time i make a selection from dropdown it drops into collection below and is removed as an option, see images below. this should give you a good starting place
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Perfect ! Much appreciated !
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Much appreciate it !