Answered

Search Using Multiple Filter Conditions

(0) Share

Report

Posted on by rajujoseph

I am currently working on a Canvas App. The Data Row Limit for the app is set to 50.

The screen has multiple fields that can be searched against. When the user clicks on Search button, the filter is applied, and resulting records are displayed in a gallery control.

In the OnVisible property, I have the following code:

UpdateContext(
    {
        locSearchResult: Blank()
    }
);

The OnSelect property of the Search button has the following code:

UpdateContext(
    {
        locSearchResult: Filter(
            MovieTitles,
            rxj_titletype in TypeCombobox.SelectedItems || CountRows(TypeCombobox.SelectedItems) = 0
        )
    }
)

The Items property of the gallery control is set to

locSearchResult

The gallery control correctly displays records and it displays & stops at 50 records (since that is the data row limit).

If I move the filter code behind Search button to the Items property of the gallery control, it displays 100 records and continues loading when I scroll down.

Question

How can I manually trigger the search and still get the gallery to load the 100 records and load more when I scroll down? Any suggestions?

Categories:

General Questions

All responses (5)

Answers (1)

Verified answer

WarrenBelz 146,601 Most Valuable Professional on at

Like (0)

Report
Search Using Multiple Filter Conditions

Hi CU23070158-1

Despite any collection workarounds that you may consider, the real question (which I asked before) is if the total number of records likely to be returned are going to exceed your Data Row Limit. If not, you can do this (a bit of a hack, but you will get all records not in batches immediately if they are under your DLR)
With( { _Data: Filter( MovieTitles, rxj_titletype in TypeCombobox.SelectedItems || CountRows(TypeCombobox.SelectedItems) = 0 ) }, _Data )

You could also do a collection (which is limited to your DLR) and filter that, but if your returned data numbers are over your DLR, you will not get the full list.

The conundrum I see is that you want the reverse of what is possible - if you have more records that your DLR, the only way to get them all is in a Delegable query (which will be in batches of 100). If you have less records, you can use what I posted (the With() statement is effectively a very temporary collection limited by the DLR).
Suggested answer

Ravindra Jadhav 263 Super User 2025 Season 1 on at

Like (0)

Report
Search Using Multiple Filter Conditions

The issue arises because the Data Row Limit applies to local variables, while delegation allows more records when directly querying the data source. To solve this:

Implement pagination using FirstN and LastN functions.

Store the results in a collection instead of a variable.

Adjust the gallery’s Items property to load the next set of 50 records when triggered by user interaction (like a button click). This allows manual control of how many records are displayed at once.

This method circumvents the 50-record limit and allows more efficient scrolling.

t formula to implement pagination with the FirstN and LastN functions, and using a collection instead of UpdateContext:

On the OnVisible property of the screen, initialize a collection:

ClearCollect(colSearchResult, FirstN(MovieTitles, 50))

On the OnSelect property of the Search button, update the collection with the next batch of 50 records:

ClearCollect( colSearchResult, Filter( MovieTitles, rxj_titletype in TypeCombobox.SelectedItems || CountRows(TypeCombobox.SelectedItems) = 0 ) ); Collect( colSearchResult, LastN( Filter( MovieTitles, rxj_titletype in TypeCombobox.SelectedItems || CountRows(TypeCombobox.SelectedItems) = 0 ), 50 ) )

Set the Items property of the gallery to:

colSearchResult

Please Closed the Question, Mark it Solved If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping Thank You Ravindra Jadhav Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7 Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/
rajujoseph 6 on at

Like (0)

Report

Search Using Multiple Filter Conditions

I am using Dataverse. My requirement is, I always want users to click the Search button to apply the filter on the gallery control and still get the result in batches.

If I use a collection and attach it to gallery, using ClearCollect if I apply the filter again, records are not returned in batches.

However, if I apply the filter on the gallery control, the results are batched.

How can I trick so that filter is applied only when Search button is clicked and I still get the result in batches.
WarrenBelz 146,601 Most Valuable Professional on at

Like (0)

Report

Search Using Multiple Filter Conditions

Hi CU23070158-1

The issue is that your Data Row Limit dictates the amount of records that can be stored "locally". In addition to non-Delegable queries, it also limits the content of Variables (such as your case), Collections and a number of other "client-side" functions such as GroupBy, AddColumns and With etc).

When however a query is Delegable (as in your case - I assume you are using Dataverse here) and is applied directly to a Table Control such as a Gallery or drop-down, your Data Row Limit is irrelevant as the query is Delegated to the data source and all required records are returned directly to the control. However for performance reasons, they are returned in batches of 100, which the user then needs to scroll down through.

So in answer to your question, you cannot change this if you want to return more records than your Data Row Limit.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
abc 123 784 Super User 2025 Season 1 on at

Like (0)

Report

Search Using Multiple Filter Conditions

If you need 100 items, then increase the Data Row Limit to 100.

Is the 100 you're getting now, so sort of duplication of data into the local variable? You might want to try using a collection instead.

There's no events that can be triggered OnScroll. However, with some ingenuity, maybe using the Gallery's OnSelect can help. You'll have to get creative and figure out when the user has clicked passed 50 records to get the "next" 50.