I have Canvas app and using EDIT/Display form with combo box feature inside data card. I have category and sub-category combo boxes. I want a cascading and reverse cascading feature so that based on category it will list down sub categories and vice versa
It is currently working only on single selection but when selecting multiple categories its only list down sub-category for the first selected category. how to solve this.
DataSource = Sharepoint LIst
Combo box Properties : AllowMultipleSelect= true and AllowSearching = True.
1. Problem Statement: Multi-select cascading filter in form data cards only filters by first selected item, not union of all selected items
2. What Doesn't Work: The same logic not working in gallery filters (cmbExpertise and cmbSubCategory)
3. What Doesn't Work: Same logic in form data cards (Category and Area of Interest)
4. Sample Formula That Fails: Filter( 'Data Source Areas of expertise', !IsBlank( LookUp( varSelectedCategories, Value = Title ) ) )
5. Debug Evidence: Filter returns correct count (34) in test label, but ComboBox Items only shows subset (16)