Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Governance and Administ...
Answered

Max records limit 2000 how to handle

(0) ShareShare
ReportReport
Posted on by

I came across many posts about the max records fetching limit is 2000. 

For the scenario where I have 500000 records and I need to fetch records based on a specific criteria which would fetch around 10000 records.

My understanding is using delegate can fetch first 2000 records meeting criteria.

I want to display all 10000 records. In this scenario Implementing pagination would help?

Or is there any optimized approach?

Please suggest how to handle such kind of scenarios.

Thank you in advance

-Pardha

Categories:
  • Pardha Profile Picture
    on at
    Re: Max records limit 2000 how to handle

    Thank you. Planning to have pagination. Hope it helps.

  • Verified answer
    devendraVelegan Profile Picture
    72 on at
    Re: Max records limit 2000 how to handle

    @Pardha 

    How are users going to use 10000 records at once?

     

    To overcome the delegation issue, you could leverage GRAPH API.

     

    https://www.youtube.com/watch?v=ZzWdXiMzA-c 

     

    Also, here are a few more videos on managing delegation.

    https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD 

     

    ====================================================

    If this response helped you in any way, please give kudos by clicking the 'Thumbs Up'/'Like' button and/or marking it as an 'Accepted Solution'. This helps others by providing a quick way to identify likely solutions to their issues.

    https://www.linkedin.com/in/devendravelegandla/ 
     

     

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Governance and Administering

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 9 Super User 2025 Season 1

#2
bscarlavai33 Profile Picture

bscarlavai33 5 Super User 2025 Season 1

#3
getsplash Profile Picture

getsplash 2

Overall leaderboard

Featured topics