Unanswered

Filter doesn't work in Power app

(0) Share

Report

Posted on by Automation6

We passed 2000 rows when using our app at work, so we are trying to apply an additional filter. However, this one does not appear to work.

SortByColumns(Filter([@'Product Inventory - Part 1'],Order="Part1" Or Order="Part2", TextInput1.Text in Title), "field_1", If(SortDescending1, Descending, Ascending))

The two filters work separately (Order="Part1" Or Order="Part2" -> this one causes more than 2000 rows to be seen), but together they no longer work.

Would anyone know how I can solve this?

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Automation6

Try this:
SortByColumns( Filter( [@'Product Inventory - Part 1'], (Order = "Part1" Or Order = "Part2") And TextInput1.Text in Title ), "field_1", If(SortDescending1, Descending, Ascending) )
Automation6 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rusk
Thanks for the quick reply!

Now when I search for something where I know there are results in both Part 1 and Part 2, I still only get the results from Part 1.
(Part 1 has 2000 entries, Part 2 just under 2000).
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Unfortunately the maximum number of items retrieved in a single call is 2000, I would suggest adding another filter to get exactly what the user needs

I hope it helps 🙂
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Good morning @Automation6

I noticed your data source is named 'Product Inventory - Part 1'. Does this data source actually have "Part2"in it?
Automation6 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! @Rusk
Yes, it's just because I also have a list with the name Product Inventory.
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I tested and it looks like the filter should be working fine...
The issue is no doubt what @victorcp mentioned