Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Sharepoint Threshold limit

(0) ShareShare
ReportReport
Posted on by

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:
  • Anchov Profile Picture
    Anchov 1,984 on at
    Re: Sharepoint Threshold limit

    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

     

  • Re: Sharepoint Threshold limit

    Thank you, I do like your said. 

  • Re: Sharepoint Threshold limit

    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.

  • timl Profile Picture
    timl 34,525 on at
    Re: Sharepoint Threshold limit

    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

     

  • Anchov Profile Picture
    Anchov 1,984 on at
    Re: Sharepoint Threshold limit

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard