cascading dropdowns using collections formula not working (invalid argument type on the =) should i be using a lookup?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

i have wish to have a cascading dropdowns dropdown 2 will use the results from dropdown 1, both from the same collection i will call Collection2, this collection 2 is made from a sharepoint list with two text columns with data input like this with the column headers item 1 and item 2

item1	item2
THING1	SUBTHING1
THING1	SUBTHING2
THING2	SUBTHING3
THING3	SUBTHING4

The apps datasource i will call collection 1

both are made using the following OnStart (i want the blank)

ClearCollect(Collection2, source2 ({item1: "",item2:""}), ClearCollect(Collection1, [@Source2]);

ClearCollect(Collection1, source1 ({itemZ: ""}), ClearCollect(Collection1, [@Source1)

The following dropdown items code doenst work? am i reading the documentation wrong or should i be using a lookup column?

Filter(collection2.item2, collection2=Dropdown1.Selected.Result)

these dropdowns are also being used in a editform if that matters too.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Assuming your First drop-down is based on Item1 with a Distinct Filter
Distinct(Collection2,Item1).Item1
Then your second drop-down should be something like
Filter( Collection2, Item1=Dropdown1.Selected.Result ).Item2
Is this what you are meaning?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No