web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Model driven Applicati...
Power Apps
Answered

Model driven Application that can connect to SharePoint

(0) ShareShare
ReportReport
Posted on by 28

Hello,

I am new to Power Apps. I just wanted to know whether we an model driven Application that can connect to SharePoint On-Premises.

 

Regards,

Kanda.

Categories:
  • timl Profile Picture
    37,424 Super User 2026 Season 2 on at

    Hi @Kandaswamyg 

    If you want to create a model driven app that can read, write, and edit records from SharePoint (both on-premises and SharePoint online), that isn't possible. The only compatible data source is the CDS.

     

  • Kandaswamyg Profile Picture
    28 on at

    Hi timl,

     

    Thanks for your response. One more question. Is there any limitation for the data in power apps?

  • timl Profile Picture
    37,424 Super User 2026 Season 2 on at

    Hi @Kandaswamyg 

    What do you mean by 'are there any limitations' for the data in power apps? Do you have any specific question in mind?

  • Kandaswamyg Profile Picture
    28 on at

    One of the article says, You can fetch max of 2000 records of data. Is that true?

  • Verified answer
    timl Profile Picture
    37,424 Super User 2026 Season 2 on at

    Hi @Kandaswamyg 

    The 2000 record limit applies to non-delegable queries.

    To help page here shows a table of delegable functions and operations.

    https://docs.microsoft.com/en-gb/connectors/sharepointonline/ 

     

     

    image.png

    Let's suppose you want to find all records where the surname <> 'smith'.

    Because the <> operator is non-delegable, PowerApps retrieves a maximum of 2000 records. If you were to use a delegable operator, the 2000 limit would not apply.

    Does that make sense?

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 204 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard