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

I have the same question (0)

All responses (6)

Answers (0)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
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) )

Was this reply helpful? Yes No
Automation6 4 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

Good morning @Automation6

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

Was this reply helpful? Yes No
Automation6 4 on at

Like (0)

Report

Hi! @Rusk
Yes, it's just because I also have a list with the name Product Inventory.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No