Unanswered

Results displaying blank results

(0) Share

Report

Posted on by 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
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

)

Was this reply helpful? Yes No
zapperrr 27 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No