Announcements
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.
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.
Hi timl,
Thanks for your response. One more question. Is there any limitation for the data in power apps?
What do you mean by 'are there any limitations' for the data in power apps? Do you have any specific question in mind?
One of the article says, You can fetch max of 2000 records of data. Is that true?
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/
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 243 Super User 2026 Season 2
WarrenBelz 204 Most Valuable Professional
Mohsin Ali 122