Announcements
//Items// FirstN(Sort( Filter( Test3, //Check if length of selected is zero, else filter by that selection Len(DropdownCanvas1.Selected.Value)=0 || DropdownCanvas1.Selected.Value = NPT.Value, Lower('Created By'.Email) = Lower(User().Email) ), ID,SortOrder.Descending ), 500 )
Hello, there are a few ways to retrieve records that exceed 2000. If you're having difficulties with this and want to fetch more than 2000 records, one suggestion is to create a collection in the app's OnStart as follows:
ClearCollection( colMore2000Records, Test3, Lower('Created By'.Email) = Lower(User().Email) ) // Up to 2000 records // 4000 records Collect( colMore2000Records, Test3, Lower('Created By'.Email) = Lower(User().Email), ID >= 2000 )
This way, it will fetch more than 2000 records.
Another suggestion is to create a pagination system that adds more records to the collection as you navigate through the pages.
If you encounter a delegation warning on the ID field, one solution is to create a mirrored column of the ID in number format. This can help resolve the delegation warning.
I hope this helps provide some guidance.
With( { _Data: Sort( Filter( Test3, Len(DropdownCanvas1.Selected.Value) = 0 || NPT.Value = DropdownCanvas1.Selected.Value, 'Created By'.Email = User().Email ), ID, SortOrder.Descending ) }, FirstN( _Data, 500 ) )
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
