Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Governance and Administ... / Slow Performance Big A...
Power Apps - Power Apps Governance and Administ...
Unanswered

Slow Performance Big App Many SharePoint Lists - What are the Options?

(0) ShareShare
ReportReport
Posted on by BClouded 174

Hi Community,
I have built a rather big power app for a customer and everything went fine until recently. The performance is really dropping and loadtimes are very high. The App uses about 20 SharePoint lists which vary in size from a few records to about 3000 records at the moment of writing. 
All those lists are connected to each other 'programmatically'. In which I mean. For example: In the InvoiceList I have a ClientID and ProjectID.
So when the user loads the gallery of invoices. For invoice there is a lookup in getting some clientdata and another lookup to get some projectdata. So of course this is generating a lot of networkrequests. 

I already decreased that delegation limit from 2000 to 1200. Since most delegation warnings I receive are not really an issue. (at least not data wise).

Loading data in a collection at startup. Does this improve performance, or is loading data in cache just decreasing performance?
The application is running on a desktop with a high enough CPU and more then enough Memory and with high speed internet connection.

Could it also be that MS is reducing our performance as it might have noticed we are using "a lot" of server resources, with a basic license?  

What are your thoughts about it? 

Thanks for thinking along.
Bart



Categories:
Management
  • BrianHanratty Profile Picture
    BrianHanratty 2 on at
    Re: Slow Performance Big App Many SharePoint Lists - What are the Options?

    I have been doing work on tables over 130000 rows in a share point list. Whilst I use the filter command and use the double pipe || to act as an OR command I have it filter across a number of columns.

    Filter(

    NEWVOID, StartsWith(PostCode,searchTerm)||

    StartsWith(UnitID,searchTerm)||

    StartsWith(AddressClean,searchTerm)||

    StartsWith('Primary Customer',searchTerm)||

    StartsWith(CRef,searchTerm)||

    StartsWith(Mobile,searchTerm)

    )

    I would consider limiting the columns to filter but the key is as described above to stop the filter searching on each keystroke. So I have put a search button in tied to the gallery but make it wait for the press so that there is one call on a reduced dataset. UpdateContext({searchTerm: TextInput_Item.Text}).

     

    Hope this helps.

  • BCLS776 Profile Picture
    BCLS776 8,988 Super User 2025 Season 1 on at
    Re: Slow Performance Big App Many SharePoint Lists - What are the Options?

    Hi Bart,

     

    See this document for service limits associated with different licences. You could be running up against the limits after a big day of testing, which would explain getting throttled. There are connector limits too, but these tend to take the form of "100 requests per 60 seconds". I don't think your app will push those limits.

     

    You can sign up for 30 day trials of premium licencing to try out. These offer higher API call limits and better service tiers (more responsive). If you notice a huge leap in performance when going to a premium licence, that's a sign you are pushing hard on the standard licence.

     

    Do take further looks at how your app handles data. Lots of community members build complex, data intensive apps using standard licencing and they work great. I find 80-90% of my customers don't need premium licencing or they need it for only a few of their accounts. Throwing more compute resources at a problem isn't the only solution.

     

    Bye for now,

    Bryan

  • BClouded Profile Picture
    BClouded 174 on at
    Re: Slow Performance Big App Many SharePoint Lists - What are the Options?

    Hi, @BCLS776 ,

    Thanks for your insights. I changed the app now, to load the most frequently asked data to load in a collection at startup. This seems to have a good impact on overall performance.

    However, is there a way I can be sure if I hit Microsoft API limits? Loading time yesterday evening after a long day of testing, and thus generating a lot of requests. App.OnStart could take 3 minutes. This morning, all data was loaded in 1 second! As you can see in the screenshot of the monitor below. I don't understand why there are such big differences in performance. The only thing I can think of is that my 'servertime' is being limited. 

    BClouded_0-1648192149626.png

     



  • BCLS776 Profile Picture
    BCLS776 8,988 Super User 2025 Season 1 on at
    Re: Slow Performance Big App Many SharePoint Lists - What are the Options?

    Your issue probably has little to do with any Microsoft-imposed API throttling or limits. The limits included with most accounts are generous, especially for a single app.

    As an app maker, you will need to make compromises/decisions on:

    • Loading data into collections, if it potentially saves you multiple reloads later
    • The number and complexity of controls on a single screen
    • How often the app refreshes data sources, automatically or using the Refresh() function
    • How many columns & rows do you load from a data source. Smart use of delegable Filter() operations helps a ton. Why load 1200 records if you need only one?
    • The underlying data structure, if everything seems like a lookup to everything else
    • Using Power Automate flows to perform operations more efficiently than you can through a Power App, but with added complexity

    There is no single "right answer" to these considerations and there's more to consider too. You may need to trade off a bit of performance for a better overall user experience, and vice-versa.

    Hope that helps,

    Bryan

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

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans