Hi,
I created a DataTable with numerous filters, however, when I search in one of the filter boxes, it still displays the blank rows which is not what I want.
For example: If I search in the Serial Number column, it displays the search result AND displays all of the rows that have a blank Serial Number. I'd like to have it only show accurate search results.
Here's the Items on my DataTable:
Sort(
Filter(
'IT Equipment List',
textInputSearch.Text in User || User = Blank(),
SInput.Text in 'Serial Number' || 'Serial Number' = Blank(),
ModelInput.Text in Model || Model = Blank(),
IsBlank(Dropdown1.Selected.Result) || 'Equipment Type'.Value = Dropdown1.Selected.Result,
IsBlank(Dropdown1_1.Selected.Result) || Location.Value = Dropdown1_1.Selected.Result
),
User
)