cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resident Rockstar
Resident Rockstar

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

Can anyone tell me what this means?  

 

image.png

 

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

Filter(Drawing_Vault,MD_ID=Gallery_MD.Selected.ID)

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.

 

1 REPLY 1
Highlighted
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.

https://community.spiceworks.com/topic/2168429-sharepoint-online-list-view-threshold-exceeded

 

Helpful resources

Announcements
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.

secondImage

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)