If we define the Items for a DataTable or Gallery to be Collection will Power app show more than 2000 items?

(0) Share

Report

Posted on by johnjohn123

3,514

Hi,

I have a DataTable which has its Items property = a collection:-

detailsed gallary items.png

and i am setting the collection as follow:-

left gallary on select.png

so let say there are more than 2,000 items which match the collection filter (SID=galItems.Selected.ID), will power app show all those items? by paging them by 100 item on each shot? or it will only show the first 2,000 items? if it will only show the first 2000 items then is there a way to force the collection to show all the items (which are > 2000)?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey!

It will show only the first 2000 itens. My advice would be filtering by month, it would be easier

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306 what do you mean by filtering by month!! i want to filter based on the SID .... so you mean we can not build a collection which hold more than 2000 items?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey! You can build a collection with more than 2k itens but it will only show the first 2k

I don´t know what "SID" is... But you can try to organize them by creation date
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306 SID is the parent ID stored inside a child record..

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ok. Again, you can only show 2k items. I don´t know how you are getting more (your other post). What you can do is try to filter by SID. Imagine, 1 button filter SID between 1-50, other 50-100,...

And so on.

Then, on gallery you had a switch that would change deppednign on the button you pressed. Like this video:

https://youtu.be/SJqbYa8Tqpk

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @johnjohn123 ,
If you want to to filter based on Last in items priority you can use FilterN(Source,Condition && ID >2000,2000); You need to manage the condition as per your requirement.
If you want to have more than 2000 items in a collection you can do that provided your App collection limit is set to 2000 and you follow below steps :
1. Server hit to the datasource to get First 2000 items from the source.
2. Server hit to the datasource to get First 2000 where ID >2000 from the source.
3. Combine these two collection and the third collection will have more than 2000 items.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123 ,

Can we also close this one on Delegation or do you want more explanation?

Was this reply helpful? Yes No