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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Connector Development / display problem
Power Apps - Connector Development
Suggested answer

display problem

(0) ShareShare
ReportReport
Posted on by CU30091332-0 6
I have an issue with PowerApps that I would like to clarify. My application displays a table of data from a PowerApps collection, itself fed by a SharePoint list. A part of the calculations is carried out directly in SharePoint. The problem is that when I scroll down the table, the data loading becomes slow. I would like to remove this slowdown. Is there a solution to optimize this?  
Categories:
Authentication
I have the same question (0)
  • Abdul Wahab Profile Picture
    Abdul Wahab 44 on at
    display problem
    1. Why it happens
      1. Delegation limits – SharePoint has delegation limits (by default 500, max 2000 records). If your formulas aren’t delegable, PowerApps pulls data client-side → slowdown.
      2. Large dataset – If the SharePoint list has many columns or rows, PowerApps loads them in chunks while scrolling.
      3. On-the-fly calculations – If formulas are applied while displaying, each scroll recalculates, adding lag.
      4. Unnecessary fields – If you pull all columns from SharePoint instead of just needed ones, it slows down rendering.
    2. Optimization Approaches
      1. Optimize your data source
        1. In your ClearCollect or Collect, load only the columns you need using ShowColumns()
        2. ClearCollect(
              colMyData,
              ShowColumns(
                  'MySharePointList',
                  "Title",
                  "Created",
                  "Status"
              )
          )
        3. If you have calculations in SharePoint (calculated columns), consider pre-computing them once instead of recalculating in PowerApps.
      2. Use Delegation properly
        1. Check your gallery filters/sorts. Avoid non-delegable functions like StartsWith, Len, IsBlank on large data. Instead, use delegable queries like Filter(Column = "Value").
        2. Use delegation warnings in PowerApps (blue squiggles) to spot non-delegable queries.
      3. Improve scrolling performance
        1. In a gallery, set DelayItemLoading = true (this makes scrolling smoother).
        2. Use LoadingSpinner (LoadingSpinner = Data or Controls) to make it user-friendly.
        3. Limit the number of records displayed (e.g., load first 100, then lazy-load more with a “Load More” button).
      4. Cache data efficiently
        1. Instead of pulling SharePoint data every time, load it once into a collection on App.OnStart or screen OnVisible.
        2. If the SharePoint list rarely changes, you can refresh periodically instead of on every scroll.
      5. Consider data source size
        1. SharePoint lists work best when under 5,000 items. Beyond that, performance drops. If you’re dealing with very large data, consider moving to Dataverse or SQL as a backend.
     
    Kindly click on 'Does this answer your question?' if my post has assisted in resolving your issue. Doing so will help others locate the solution more efficiently and will also mark the item as closed. Additionally, if you found the content beneficial in other ways, please consider giving it a Like.
     
    Abdul Wahab
    Direct: +923323281237
    Email: abdulwahabubit@outlook.com
    LinkedIn: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
    Twitter: https://twitter.com/Abdulwahabubit
    GitHub: https://github.com/AbdulWahabWarind
    YouTube: https://www.youtube.com/channel/UCBjgLqLK_2kU-3bwo4McrTw
     
  • WarrenBelz Profile Picture
    WarrenBelz 151,118 Most Valuable Professional on at
    display problem
    I will focus on this statement A part of the calculations is carried out directly in SharePoint. If you are referring to a SharePoint Calculated Column, then these are unreliable with Power Apps and should not be used for (particularly) any calculations or filters. If this is not the case, please disregard this post.
     
    Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
    Visit my blog Practical Power Apps    LinkedIn  
  • Suggested answer
    CU30091332-0 Profile Picture
    CU30091332-0 6 on at
    display problem
    @Abdul Wahab salut , Je t'explique bien ces problèmes. J'ai une galerie qui récupère plus de 2000 données et montre un retard dans les données. Je veux déboguer pour que les données s'affichent plus rapidement. J'ai utilisé une autre application PowerApps et j'ai utilisé une galerie. Elle récupère les données à SharePoint, mais elle n'a pas de problème d'affichage. Est-ce que peut-être le problème est plus lent d'afficher les données de l'autre application ?  Problème de code ou quoi ?? je ne comprends pas bien ce qu'est la méthode de délagation ?

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 790 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 473

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 383 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans