cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LionelCharley
Frequent Visitor

Power Apps and SharePoint list

Hello,

 

I am planning to create a work order power apps application. The backend will be SharePoint list and the front end will be Power apps. This SharePoint list is going to have 15,000 items(work orders) in a year based on our historical records. 99% of the WO are opened and closed in the same month.

 Is it ok building the app using SharePoint as a backend? Please advise

 

Thanks

Lio

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@LionelCharley ,

If in your queries, don't expect more than 500-2000 records (this can set manually from PowerApps and affects proportionally the responsiveness of the app) to currently work with in PowerApps app, Sharepoint list can be a good choice as a datasource. 

The great advantage of Sharepoint to be used as PowerApps datasource is that you don't need supplementary licences (and of course supplementary costs), but if you need to do complex queries on the datasource server side and bring the results data in PowerApps app it is recommended to use specialized database servers like SQL.

 

View solution in original post

3 REPLIES 3
faouwerx
Frequent Visitor

Hi,

First you might encounter issues within SharePoint and specific functionalities (views, groupings etc) when lists exceed 5000 items. Other than that, SharePoint lists may comprise millions of items.

See details on this here 

 

Within the PowerApp, you might encounter some issues if you use non delegable functions when lists have more than 500 items. More details here.

 

I hope this helps

gabibalaban
Super User
Super User

@LionelCharley ,

If in your queries, don't expect more than 500-2000 records (this can set manually from PowerApps and affects proportionally the responsiveness of the app) to currently work with in PowerApps app, Sharepoint list can be a good choice as a datasource. 

The great advantage of Sharepoint to be used as PowerApps datasource is that you don't need supplementary licences (and of course supplementary costs), but if you need to do complex queries on the datasource server side and bring the results data in PowerApps app it is recommended to use specialized database servers like SQL.

 

Thank you both for helping on this

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,921)