Galleries showing more than 100 items.

[MattyH]

Hi,

I have an app, which already works very well, which enables our different sites to record animal weights. I use a gallery to list all of the animals in a particular stable, but some stables are very large, and hold up to 200 animals.

As the animals (rather inconsiderately, in my opinion!) do not tend to go through the weigh gate in alphabetical order, our grooms need to scroll through the names of the animals to find certain individuals.

If one of the animals is low on the list alphabetically, it does not show in the initial load of the gallery, which appears to only load the first 100 items, meaning our grooms need to scroll to the bottom, then wait while the gallery reloads the remaining animals.

I already have a search box, so the list can be filtered by name, but I want a better experience when the user is scrolling through the list.

I guess my main question is; is there a way to change the gallery limits to show more items in the initial load?

If not, then the users will just have to deal with it as it is!

Thanks

Matty.

[v-xida-msft · Accepted solution]

Hi @MattyH ,

Do you want to change the initial load limits within the Gallery control?

If you want to change the initial load limits within the Gallery control, I afraid that there is no way to achieve your needs in PowerApps.

If you would like this feature to be improved in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

[K-A-R-L]

Hi @MattyH ,

What is your data source?

Try adding:

 FirstN(DataSource,500) //this will give you top 500 from your list.

----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

[MattyH]

@v-xida-msft  Thanks. I assumed as much, just wanted confirmation.

@K-A-R-L the datasource is Dynamics365, but the list is filtered, a lot.

Thanks

Matty.

[Fellmeth]

Thanks K-A-R-L,

Sometimes the solution is so simple!

[AJ_vizMan]

@K-A-R-L  - So true, sometimes solution is pretty simple. You made our life easy. Thank you

[Anonymous]

Thanks, K-A-R-L. Your solution is so simple and works. I really appreciated your help and very happy I found it near 3 years you posted.

[iskguy]

I know this is more than a few years old, but is something that resolved my issue today

[dboyd]

This is great fix! Thanks for sharing

[MW]

If you ran in the same issue, being unable to load all items in a Gallery, please vote and support this idea: Enable the option to load all items in a Gallery · Community (powerapps.com)