Announcements
Hello everyone Items are loading according to scroll downI want to know how can I load data in gallery without need to scroll down until last itemI have some math operations that need to load all data (It will be max 40 itens)
Hi @t1agow ,This heavily depends on the number of items you have and also your screen size. Have in mind the number of items and your screen size.
@Silvester With filters It would be max 40 itemsI want to know how can I get the values without scrolling down (I'm using Gallery.Allitems)The value updates accordingly by scrolling down (I don't want to have to scroll down for the value to update with all values in operation)I hope it was clearerThank you in advance
Gallery.AllItems will return all the values depending on the filter that you use. Additionally, scrolling down doesn't update the values, the values are there after the process run. By default, PowerApps loads up to 500 records at a go, expendable to 2000 records. As I said earlier, it heavily depends on your screen, of course you can still squeeze up the items to better use the space. Using horizontal gallery might help. You can check this video from Reza Dorrani https://youtu.be/bnC8u3gdWss
@Silvester Sorry, I think you still don't get the pointI have a textbox that sum all itens in gallery according to the users filterAn example:
If he uses the filter = banana, this gives me 10 items, which multiplies by the value 10, we will have a total of 100. However if he filters again (banana+apple) the value will remain 100 until he scrolls down to gallery to load the items, only then it will change from 100 to the value it should be.I want that values load without need to scroll down (It will always have to scroll down, because the gallery has items that need space). I would like to know if this is possibleI imagine having no performance problems because It will be max 40 itensThank you
Hi @t1agow ,
Please use FirstN function.
I have a list with 300 items and this is the sample:
Best Regards,
Wearsky
Hello @t1agow ,i now get you.Try the FirstN @v-xiaochen-msft suggested. Let me know how it goes.
@v-xiaochen-msft @Silvester Thank you for answering me!I tried and It still don't work, value just change when I scroll down like you can seeI recorded It for you to understandI'm using this formula for value field:
cronoTot multiplies the value of 'Peso' * 'Cronograma combobox'
metTot multiplies the value of 'Peso' * 'Metodo combobox'
Try this, Instead of filtering on the Gallery.AllItems, try using the data source to filter as in
Filter([@DataSource], filtroNome.Selected.Result="Belt")
So instead of using the Gallery, use the datasource itself, and do the CountRows on the result of the filter, do let me know how it goes
@Silvester Sum is not delegable in sharepoint conector but I create a collection and I think that problem is solvedThank you!!
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)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 429 Most Valuable Professional
11manish 191 Super User 2026 Season 2
MS.Ragavendar 122 Super User 2026 Season 2
