Missing Entries

(0) Share

Report

Posted on by zapperrr

Hi,

I have a few filters step up just to search the datatable I have, along with a sort column function.

However, it's missing a few specific rows. Anytime I remove one of the filters, more rows appear which shouldn't be the case. I'd like everything to populate in the datatable while keeping the search functionalities I have set up.

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

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

zapperrr 27 on at

Like
a
(0)

Report
Copy link

Link copied!

To add on, I have only about 360 rows and confirmed this with the SharePoint list and an Excel sheet.
zapperrr 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the chain of messages, I'm troubleshooting as I go. I found out those missing entries are a result of the column it is filtering being blank. Is there a way to get around it so I can leave it blank and still be able to filter to it?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@zapperrr

Which column is it that you are finding the issue with?

Are you wanting to include the record that has the blank column, or exclude it?
zapperrr 27 on at

Like
a
(0)

Report
Copy link

Link copied!

The Serial Number column. If it's blank, it won't show. I wish to change that so it shows even if blank.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@zapperrr

Sure, then you can change the formula to the following:

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