I have a data table that is currently able to dynamically filter off of a bunch of different measurements. Recently, we have added a specifications column in our data table and we want to be able to select multiple values from it and have the data table reflect that. Currently it only works if we select one value from the specifications combo box. Any advice would be appreciated.
Here is the formula in the specifications combo box
SortByColumns(
Distinct(
Search(
Filter(
_masterCollectionAll,
(material_family = 'Compound Selection_1'.Selected.Result && parent_category = Part_Select_Gallery.Selected.Parent_x0020_Category_x0020_Code && sub_category = Part_Select_Gallery.Selected.Subcategory_x0020_Code) &&
(_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(_materialManuf) || material_manufacturer = _materialManuf) &&
(IsBlank(_color) && color <> Blank()) || color = _color),
'Part Number/Description Searchbox_3'.Text,"item_id","item_desc","size"),
specifications).Result,
"Result", Ascending)
Here is the code currently on the data table:
SortByColumns(
Search(
Filter(_masterCollectionAll,
(material_family = 'Compound Selection_1'.Selected.Result && parent_category = Part_Select_Gallery.Selected.Parent_x0020_Category_x0020_Code && sub_category = Part_Select_Gallery.Selected.Subcategory_x0020_Code),
(IsBlank(outerdd_3.Selected.Result) || outer_diameter = outerdd_3.Selected.Result),
(IsBlank(innerdd_3.Selected.Result) || inner_diameter = innerdd_3.Selected.Result),
(IsBlank(cross_sectiondd_3.Selected.Result) || cross_section = cross_sectiondd_3.Selected.Result),
(IsBlank(mat_compounddd_3.Selected.Result) || material_compound = mat_compounddd_3.Selected.Result),
(IsBlank(durometer_dd_1.Selected.Result) || durometer = durometer_dd_1.Selected.Result),
(IsBlank(Material_manf_dd.Selected.Result) || material_manufacturer = Material_manf_dd.Selected.Result),
(IsBlank(color_dd_1.Selected.Result) || color = color_dd_1.Selected.Result),
(IsBlank(Specification_Combobox_3.Selected.Result) || specifications = Specification_Combobox_3.Selected.Result)
)
,'Part Number/Description Searchbox_3'.Text,"size","item_id","item_desc","supplier_part_no"),
// Dynamic sorting and sort order
First(_sortingTable).Value, If(First(_sortingTable).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 2)).Value, If(Last(FirstN(_sortingTable, 2)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 3)).Value, If(Last(FirstN(_sortingTable, 3)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 4)).Value, If(Last(FirstN(_sortingTable, 4)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 5)).Value, If(Last(FirstN(_sortingTable, 5)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 6)).Value, If(Last(FirstN(_sortingTable, 6)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 7)).Value, If(Last(FirstN(_sortingTable, 7)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 8)).Value, If(Last(FirstN(_sortingTable, 8)).SortOrder = true, Ascending, Descending),
Last(FirstN(_sortingTable, 9)).Value, If(Last(FirstN(_sortingTable, 9)).SortOrder = true, Ascending, Descending)
)
Here is an image of what the app currently looks like:
Solved! Go to Solution.
Figured out what I needed to do. It was simple. I just had to turn on multiple selections and change it to .selecteditems and the = to an 'in'
Figured out what I needed to do. It was simple. I just had to turn on multiple selections and change it to .selecteditems and the = to an 'in'