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 Dropdown in ...
Power Apps
Answered

Cascading Dropdown in powerapp

(0) ShareShare
ReportReport
Posted on by 428

I have created two drop-down and i am able to cascade it, but now i have four drop-down and want to cascade other 3 drop down  it on any drop-value selection 

Categories:
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Ashok2 ,

    Could you please share a bit more about your scenario?

    Do you want to create a cascading Dropdown boxes between four Dropdown boxes?

    Further, do you want to populate other 3 Dropdown boxes against any Dropdown box selection?

     

    Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs. If you configure the cascading Dropdown boxes based on any Dropdown box selection directly, I afraid that you would face circular reference issue within your Dropdown boxes.

     

    The user @CRM-Kfar-Sava has faced similar issue with you, please check my response within the following thread:

    https://powerusers.microsoft.com/t5/Building-Power-Apps/CRM-lookup-Circular-reference-between-properties-problem/td-p/195180

     

    Add four ComboBox control within your app, then configure these ComboBoxes as below:

    For ComboBox1:

    Set the OnChange property to following:                        

    Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
    Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
    Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
    Set(SelectedColumn1, ComboBox1.Selected.Value);

    Set the Items property to following:

    Filter(
     'Data Source',
     If(
     !IsBlank(SelectedColumn2),
     Column2 = SelectedColumn2,
     true
     ),
     If(
     !IsBlank(SelectedColumn3),
     Column3 = SelectedColumn3,
     true
     ),
     If(
     !IsBlank(SelectedColumn4),
     Column4 = SelectedColumn4,
     true
     )
    )

     

    For ComboBox2:

    Set the OnChange property to following:                        

     

    Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
    Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
    Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
    Set(SelectedColumn2, ComboBox2.Selected.Value);

     

    Set the Items property to following:

     

    Filter(
     'Data Source',
     If(
     !IsBlank(SelectedColumn1),
     Column1 = SelectedColumn1,
     true
     ),
     If(
     !IsBlank(SelectedColumn3),
     Column3 = SelectedColumn3,
     true
     ),
     If(
     !IsBlank(SelectedColumn4),
     Column4 = SelectedColumn4,
     true
     )
    )

     

     

    For ComboBox3:

    Set the OnChange property to following:

     

    Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
    Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
    Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
    Set(SelectedColumn3, ComboBox3.Selected.Value);

     

    Set the Items property to following:

     

    Filter(
     'Data Source',
     If(
     !IsBlank(SelectedColumn1),
     Column1 = SelectedColumn1,
     true
     ),
     If(
     !IsBlank(SelectedColumn2),
     Column2 = SelectedColumn2,
     true
     ),
     If(
     !IsBlank(SelectedColumn4),
     Column4 = SelectedColumn4,
     true
     )
    )

     

     

    For ComboBox4:

    Set the OnChange property to following:

     

    Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
    Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
    Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
    Set(SelectedColumn4, ComboBox4.Selected.Value);
    

     

    Set the Items property to following:

     

    Filter(
     'Data Source',
     If(
     !IsBlank(SelectedColumn1),
     Column1 = SelectedColumn1,
     true
     ),
     If(
     !IsBlank(SelectedColumn2),
     Column2 = SelectedColumn2,
     true
     ),
     If(
     !IsBlank(SelectedColumn4),
     Column4 = SelectedColumn4,
     true
     )
    )

     

     

    Please take a try with above solution, then check if the issue is solved.

     

    Best regards,

  • srosenbloom Profile Picture
    35 on at

    A MILLION, BILLION, GAJILLION TIMES THANK YOU FOR THIS!! I've been trying to get this to work for a few weeks now, and this was dead on the solution!  Really! Thank you so much!

     

    Scott

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard