Notifications
Announcements
Hi, I have to display more than 2000 rows in app, my source is Sql table.
Can you please help me on this.
Thanks,
Pankaj
My gallery will display more than 2,000 rows from my SQL table. Are you filtering the data using a non-delegable function that could be limiting you to the 2,000?
@Jeff_Thorpe; I am using non delegatable function in my filter function that limiting me to 2000 records, is there a way to show more than 2000 records for non delegatable function
Hi @Anonymous,
You could take a try to first collect the table into a collection with delegable functions, then working with the collection with the non-delegable function.
For example:
ClearCollect(Tmp, SQLTableName)
then use the Tmp to perform filters or calculations with in App.
Take a look at the article below for the Delegable functions for SQL Server and the other data sources:
Delegable data sources
Besides, you may follow the steps mentioned by mr.Dang through the following link:
Overcoming the 500 record limit locally
Regards,
Michael
Instead of Filter function use Search that should resolve the issue.
SEARCH is delegable function
https://shaheer365.blogspot.com/2023/05/retrieving-more-than-2000-rows-from.htmlcheck if this works for sql also.please give thumbs up and accept as solution if ur problem is solved
thanks
Did you find the solution?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
