Power Platform Community Forum Thread Details

Hi, I have this inventory catalog app I'm building and it was previously working fine, but now after making some needed changes my dropdown filters are not working properly. Basically in the code below the filter is based on previous gallery selection screens and then it takes the user into a master data table based on their selections. They can filter the data table further based on different dropdowns, but we wanted the dropdowns to be dynamic of each other, hence the code below. The issue is it doesn't bring back everything, it just throws me this error.

Code:

SortByColumns(
 Distinct(
 Search(
 Filter(
 '[dbo].[970_item_format_item_mast]',
 (material_family = 'Compound Selection_1'.Selected.Result && parent_category = 'O-Ring Gallery'.Selected.Parent_x0020_Category_x0020_Code && sub_category = 'O-Ring Gallery'.Selected.Subcategory_x0020_Code && material_manufacturer = 'Material Man Select'.Selected.Result) &&
 (_outerDiameter = 0 || outer_diameter = _outerDiameter) &&
 (_innerDiameter = 0 || inner_diameter = _innerDiameter) &&
 (_crossSectionMeas = 0|| cross_section = _crossSectionMeas) &&
 (IsBlank(_durMeasurement) || durometer = _durMeasurement) &&
 (IsBlank(_materialCompound) || material_compound = _materialCompound) &&
 (IsBlank(_color) || color = _color) &&
 (Not(First(Filter(Spec_ComboBox_2.SelectedItems, Result = "REACH")).Result = "REACH") || reach = "REACH")&&
 (Not(First(Filter(Spec_ComboBox_2.SelectedItems, Result = "RoHS")).Result = "RoHS") || rohs = "RoHS")),
 'Part Number/Description Searchbox_2'.Text,"item_id","item_desc"),
 color).Result,
"Result", Ascending)

This dropdown is for the color of the part and when I click on result it brings back one color, but then throws me the error