Power Platform Community Forum Thread Details

I'm using multiple dropdowns to filter a gallery of materials located in a SharePoint library. The gallery is working correctly, but I want to edit the dropdowns so that each dropdown only shows available results depending on what the others have selected. For example, if I change 'Objective' I want the other dropdowns to only show the SharePoint items that have that particular objective, at the moment they show all results regardless.

Here is the name of each dropdown and their 'items' settings:

Objective filter: Sort(collectObjective,Result,SortOrder.Ascending)

Product filter: collectProduct

Brand filter: Sort(collectBrand,Result,SortOrder.Ascending)

Customer filter: Sort(collectCustomer,Result,SortOrder.Ascending)

Media filter: Sort(collectMedia,Result,SortOrder.Ascending)

What's the best way to connect these so the dropdown results are dependant on each other? Thanks!