web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / cascading dropdowns us...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 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

 

item1item2

THING1

SUBTHING1
THING1SUBTHING2

THING2

SUBTHING3
THING3SUBTHING4

 

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:
I have the same question (0)
  • WarrenBelz Profile Picture
    154,930 Most Valuable Professional on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard