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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cascade on Multi Choic...
Power Apps
Unanswered

Cascade on Multi Choice Column

(0) ShareShare
ReportReport
Posted on by
I have the following issue.
 
I have created a dataverse table in this way
 
Product Group    Business Unit
A                         X
B                         X, Y, Z
C                         Y,X
D                         X, Z
 
The Product Group is a simple text field, but the Business Unit is a Global Choice column as I am using the Business Unit in various other tables to choose.
Now, I want to use a cascading filter on Combobox2 to select the Product based on prior selection on Business Unit.
 
Combobox 1 : selected Business Unit = Z (Single Selection only!)
Combobox 2:  Only Productgroup B and D should appear
 
I have the same question (0)
  • Gil0 Profile Picture
    94 on at
    Hello,
     
    Since you would like to display results based on the first combo box selection, this might be the approach you are looking for:
     
    In Combobox 2, Items Property,
     
    Filter(YourTable, 'Combobox 1'.Selected.Value in 'Business Unit')
     
    This should then only return results matching just the business unit selected.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 740 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 342 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard