Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id : BEStS31bkkZOzITsP7TxnV
Power Platform Community / Forums / Power Apps - Building Power Apps / Get data from SharePoi...
Power Apps - Building Power Apps
Answered

Get data from SharePoint list that has more than 2000 records?

Like (0) ShareShare
ReportReport
Posted on 7 Jul 2020 02:30:11 by Community Power Pla...

Dear all,

 

Does anyone know how I can get data from SharePoint list that has more than 2000 records?

 

Thank you very much.

Categories:
Using Apps Using Formulas
General Questions
Connecting to Data
  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft on 07 Jul 2020 at 07:14:25
    Re: Get data from SharePoint list that has more than 2000 records?

    Hi @Anonymous :

    Because your data source is SharePoint, as long as your formula is delegable, then you can get more than 2000 records.

    Power Apps delegable functions and operations for SharePoint

    The following Power Apps operations, for a given data type, may be delegated to SharePoint for processing (rather than processing locally within Power Apps).

    1.JPG

    I think these links will help you a lot:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

    https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

    In addition,you can distinguish whether the formula is delegated by delegation warning (a small yellow triangle).If your formula is not delegable, then try to use functions that can be delegated instead of non-delegable functions.

    Best Regards,

    Bof

  • Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on 07 Jul 2020 at 03:13:41
    Re: Get data from SharePoint list that has more than 2000 records?

    Hi @Anonymous 

    Review this video please. https://m.youtube.com/watch?v=gwiErbYtRdA .It will help you understand how PowerApps interacts with SharePoint

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

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 - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 223 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 110

#3
stampcoin Profile Picture

stampcoin 86

Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans