Results displaying blank results

[zapperrr]

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
)

[Drrickryp]

@zapperrr 

Sort(
  Filter(
       'IT Equipment List',
        textInputSearch.Text = Blank() || textInputSearch.Text in User ,
        SInput.Text= Blank() || SInput.Text in 'Serial Number' ,
        ModelInput.Text = Blank() || ModelInput.Text in Model| ,
         IsBlank(Dropdown1.Selected.Result) || 'Equipment Type'.Value = Dropdown1.Selected.Result,
         IsBlank(Dropdown1_1.Selected.Result) || Location.Value = Dropdown1_1.Selected.Result

   ), User

)

[zapperrr]

Thanks for the response!

Unfortunately this does not work, it blanked everything out but I do see what you did - this only hid the blank values. I'd like for it to show the blank values but only filter the things I put into the search box.