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:
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