Announcements
Hello, my data source is excel spreadsheet and I have now over 2000 records. I have tried with naming first 2000 BatchID = "1" and anything over that BatchID ="2" then creating collections depending on BatchID but this did not seem to work at all as the gallery still only can see these 2000rows. I can't delete any record from this table as well as all of them are quite important. Any ideas, please?
Regards
Hi @marcy_pi ,
Assuming "2" is a string (not a number), what do you get when you do this
ClearCollect( YourCollection, Filter( TableName, BatchID = "2" ) )
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.
Visit my blog Practical Power Apps
Hi! Thanks for a reply. It shows me only record number 2001 nothing else. Just one record in a gallery.
Yes - Excel and Delegation - if all the records have BatchID of "2", then this is an Excel limitation - I do not use it, but understood that would work. I suggest you change to SharePoint if you can.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 421
WarrenBelz 345 Most Valuable Professional
Kalathiya 278 Super User 2026 Season 1
