Showing results for 
Search instead for 
Did you mean: 
Resident Rockstar
Resident Rockstar

Exceeds Threshold Enforced by the Administrator - what does this mean?

Can anyone tell me what this means?  




My work around is to make a gallary with just the filter...  GalleryDV_invisible


And then my visible Gallery:

SortByColumns(GalleryDV_invisible.AllItems,"DV_RevisionNumber", Descending)

Why does this not work as one statement?


The results are only a few items.  Never more than 15 records.


Super User III
Super User III

Re: Exceeds Threshold Enforced by the Administrator - what does this mean?

Hi @martinav 

This is what I think is happening. A single formula that both sorts and filters the Drawing_Vault list results in a query that causes SharePoint to lock the underlying SQL Server table. This is the cause of the "Exceeds Threshold Enforced by the Administrator" error. Separating the filter and sort operation into 2 different places in your app simplifies the query and prevents this error from happening. The post here contains a bit more detail on this behaviour.


Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,843)