Power Platform Community Forum Thread Details

Hi,

I'm using cascding filters where the options of a combobox are dependent on the value selected in another combobox.

E.g., if the options for combobox 1 are [Dog, Cat... etc], and I selected dog, then combobox 2 would display [Golden retriever, labrador, etc...] and if cat was selected then it would show cat breeds (I am a dog person if you can't tell).

I'm having trouble filtering the gallery however, where I'm basically get errors on combobox 2 (the filter which has conditional options) where it says:

"Invalid Argument type: cannot use text values in this context"

Please see the code I have used in the gallery

(HubFilter is combobox 2 in this instance)

Sort(
 Filter( 
 'CVs Library',
 (Grade in GradeFilter.SelectedItems || IsBlank(GradeFilter.SelectedItems))
 && ('Base Location' in BaseLocationFilter.SelectedItems || IsBlank(BaseLocationFilter.SelectedItems))
 && ('Security Clearance'.Value = SCFilter.Selected.Value || IsBlank(SCFilter.Selected.Value))
 && ('Capability Hub' in HubFilter.Selected.Value || IsBlank(HubFilter.SelectedItems))
 && ('Capability Team' in CTFilterCV.SelectedItems || IsBlank(CTFilterCV.Selected.Value))
 ), 
 Name, 
 SortOrder.Ascending
)

PS any advice on optimising the query as I am getting delegation warnings on the ANDs is also appreciated

Categories:

Building Power Apps