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,399 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!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard