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