Notifications
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
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
Thank you, I do like your said.
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.
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
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 428
WarrenBelz 374 Most Valuable Professional
MS.Ragavendar 333 Super User 2025 Season 2