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
Super User

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,010)