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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sharepoint Threshold l...
Power Apps
Unanswered

Sharepoint Threshold limit

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi guys,

I have a sharepoint list. In this list, there are 5169 item. According to this list, I am showing some information in the powerapps gallery. However, I am getting an error. How to solve this threshold error

urhanmustafa_0-1698836735083.png

 

 

Categories:
I have the same question (0)
  • Anchov Profile Picture
    1,986 on at

    You should be able to view SharePoint lists well beyond the 5000 view limit threshold as long as you are using supported delegable operations like filtering and sorting in your Power App. For more information on these supported functions and operations, please refer to the guidance provided by Microsoft here: Power Apps Delegable Functions and Operations for SharePoint.

    However, I also recommend exploring the use of enterprise-grade data sources like Dataverse or SQL for better performance and access to a wider range of supported delegable operations, especially when dealing with large data sets.


    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Cheers!
    Rick Hurt

  • timl Profile Picture
    36,753 Super User 2026 Season 1 on at

    Hi @Anonymous 

    You can remove this error by indexing the fields that are referenced. There are more details here.

    http://powerappsguide.com/blog/post/large-sharepoint-list-fix-list-view-threshold-error

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi, thank you for reply. I do like your said. 
    Now I have different problem. I am using Distinct formula in the dropdown. But due to row limit it is not true. How to solve it.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you, I do like your said. 

  • Anchov Profile Picture
    1,986 on at

    The distinct function is subject to delegation limits in SharePoint. Try workaround suggested by @WarrenBelz in his blog:

    https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Delegation-workaround-Distinct-values-for-a-large-list-field-in/ba-p/1705721

     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard