selecting multiple records in gallery

(0) Share

Report

Posted on by Krishna_R

525

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Krishna_R 525 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri ,
yes until & unless the user scrolls till down remaining records are won't come up. hope there might be a work around for this

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Krishna_R what's the Items property of the Gallery?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Krishna_R

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.

Was this reply helpful? Yes No
Krishna_R 525 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
SortByColumns(SQLTable,"Modified")

Was this reply helpful? Yes No
Krishna_R 525 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
if we can limit 1000-2000 items. is there a way to selectall option at a time ?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Krishna_R

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

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.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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,
Load the records into a collection. ClearCollect(myCollection, SortByColumns(SQLTable,"Modified"))
Add one extra column to this collection , IsSelected. AddColumns(myCollection, "IsSelected")
Set this collection in the Items property of the Gallery.
Set ThisItem.IsSelected as the default property of the checkbox in the Gallery.
In the OnCheck of the SelectAll checkbox, ForAll(collection, Patch(collection, ThisRecord, {IsSlected:true}).
In the OnUnCheck of the SelectAll checkbox, ForAll(collection, Patch(collection, ThisRecord, {IsSlected:false}).

Was this reply helpful? Yes No