You’re offline. This is a read only version of the page.
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?
Share
ReportFilter(collection2.item2, collection2=Dropdown1.Selected.Result)
these dropdowns are also being used in a editform if that matters too.
Hi @Anonymous ,
Assuming your First drop-down is based on Item1 with a Distinct Filter
All responses (
Answers (
154,930
Distinct(Collection2,Item1).Item1Then your second drop-down should be something like
Filter(
Collection2,
Item1=Dropdown1.Selected.Result
).Item2Is 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.
