Power Platform Community Forum Thread Details

Hello Everyone,

Good day!

I need your help on how I can improve the performance when clicking a button.

I have this collection that contains thousand of data/entries and there are two buttons used to filter the display in gallery.

example: the button one filters the collection request on which status = 'complete' and the other button filters the same collection with status = 'freeze'. The problem is when clicking button 1 from button 2 or vise versa it loads like 10-15 sec. Is this normal or still can be improve?

Sample code of button 1:

ClearCollect(
 colFilteredUserRequests,
 Filter(
 colUserRequests,
 Status.Value = 'Complete'
 )
);

Sample code button 2:

ClearCollect(
 colFilteredUserRequests,
 Filter(
 colUserRequests,
 Status.Value = 'Freeze'
 )
);

Sample image: I click draft but takes 10-11 sec of time to load

Categories:

Building Power Apps

Hi @YamiteKudasai ,

As you mentioned there are thousands of entries in the source collection, and currently you are creating several collections from blank based on the buttons clicking and filter on a choice column value, this two actions will both cost time.

I would provide you another approach to accomplish this scenario with better performance:

1. Change that choices type column to text while creating the source collection, use AddColumns function:

ClearCollect(
 colUserRequests,
 RenameColumns(
 DropColumns(
 AddColumns(
 YourTable,
 "Status2",
 ThisRecord.Status.Value
 ),
 "Status"
 ),
 "Status2",
 "Status"
 )
)

2. OnSelect of those buttons, set to a variable to include the text, e.g. Active button:

UpdateContext({Qtext: "Active"})

3. Use the variable as the criteria in the filter and append in Items of the Gallery:

Filter(
 colUserRequests,
 Status = Qtext
)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community site session details

Improve Powerapps Performance when clicking buttons to Filter Collection

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates