You’re offline. This is a read only version of the page.
Announcements
40
I have used PowerApps with SharePoint lists and Azure SQL DB for few apps but now I want to use it for large data set and I know we have certain limitations with the PowerApps in terms of delegation on various functions.
If anyone used PowerApps for large data sets then please suggest what to take care of while selecting the right backend. This app will be used from many locations and role-based features I need to include.
so, Which backend source is best with PowerApps if I have to work with more than 50k records Azure SQL server or SharePoint?
Hi @edobaria
Without a doubt, SQL Server is far better than SharePoint if you need to work with 50K record sets and more.
It provides far better support for delegable operators compared to SharePoint. It's possible to optimise performance even further with views, stored procedures, indexes, etc.
Other areas where SQL Server outperforms SharePoint include supporting for importing/exporting data, backing up data, scripting, and 3rd pary tooling support.
Share
Report
All responses (
Answers (
