You’re offline. This is a read only version of the page.
Hi Reader,
I'm having a gallery with 5000 records, when i click select all option I'm able to get only 100 records out of 5000
the formula i was using is filter(gallery.allitems, cbox.value)
@Krishna_RPowerApps does not load all the items into the Gallery in the beginning. Items get loaded as you scroll. When you try to set the checkbox to true it will not work. But you can do this,
This worked for me to change the name of one of the products in a fictitious financial sample list.
You could modify the formula to meet your needs
Share
Report
All responses (
Answers (
With(
{
fs: Filter(
Financialsample,
Product = "Amarilla"
)
},
ForAll(
fs,
Patch(
Financialsample,
LookUp(
Financialsample,
ID = fs[@ID]
),
{Product: "Amarillo"}
)
)
)It takes a while but worked well on a large data set.
if we can limit 1000-2000 items. is there a way to selectall option at a time ?
It seems ridiculous to expect a user to search through 5k records to choose from in a gallery. It makes more sense to filter the galleries items property first and then select records.
I can select all the record i see in gallery. I just remember i have this in one my apps.
I haven't scroll the gallery and when i clicked select all it selected all 507 records.
Checkbox inside the gallery is named Checkbox1
Checkbox outside gallery is named Checkbox2.
Checkbox1.Default: Checkbox2.Value
because the initial load limit is 100. I don't think there is a direct solution for that. Maybe someone here has a work around for that.
when you scroll the gallery to the bottom it will select more records.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
