Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

ANy way to use TOP function in collection

i have created a collection which stores the Groupmembers from Azure, i wanted to use top function to get the all the records

my formula is

Filter(Storemembers,Getresult.Text in displayName)

with this formula my gallery loads 100 records. this is the limitation i see in some controls. any one can suggest how to improve the forumal to get all the records in the gallery even i have change the 2000 in settings in the studio


Resolver I
Resolver I

To solve the delegation issue, try:

Filter(Storemembers, displayName = Getresult.Text)


for more, check:


Anyways, I'm not sure what ,,TOP function" is.

TOP is used to get the number of records that fetch more than 500 as defualt the gallery control load only 100 records that my issues . based on my formula i ma getting only 100 records

so my question is  "can we use {top:999} records to load in gallery with the help of collection



I'm pretty much sure the Gallery control allows us to show max. +100 rows per 'scroll to the bottom'.


This means that all data are presented in the gallery, but you need to scroll down until you see them. (easily said)

Yes, I do enable scroll bars and navigation even though i could not load more that 100 records very strange


try to change your code to this:

Filter(Storemembers, displayName = Getresult.Text)

nothing is showing in the gallery,


Resolver I
Resolver I

Maybe try to display it directly through your datasource. I don't know how does your collection look like.

i had ttried that i can fetch the record but still the same 100 records can be searchable


Resolver I
Resolver I

I don't know how to help, sorry.


The easiest way is to set the gallery's Items property to your datasource and filter inside that

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,062)