Announcements
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
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
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
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.
Thank you, I do like your said.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 545 Most Valuable Professional
Haque 314
Kalathiya 234 Super User 2026 Season 1
