We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Microsoft O365 SharePoint Limit

Matt Pinkston
on
117 Views
Last Modified: 2017-06-12
We have a SharePoint custom list that was developed in SPD2010, it consists of three lists..

List1 - Main Dashboard records
List2 - Record Detail
List3 - Record History

From the main Dashboard display of List1 the use can click a hyperlink to open that records detail from List2?ID=@ID

That display is two webparts, webpart1 on filters List2 for ID=ID, webpart2 then shows all the history update record from List3 where ID=ID

worked fine under 2010 and works fine under o365 unless List3 exceeds 5000 lines.   Even though we have a filter on the webpart we get the following error...

The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.


Is there ANY WAY to correct this?
Comment
Watch Question

Walter CurtisSharePoint AED
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
You would need to further filter the list so that the number of items displayed, (not total number of items in list), is under the threshold. Not sure what kind of filter you could add because I don't know the list, but some common filters are date and name filters.

Hope that helps...
Matt PinkstonEnterprise Architect

Author

Commented:
yes our filter is currently only showing 20 records which is why we are confused
Walter CurtisSharePoint AED
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
That's weird. I agree, it has me confused too. Wonder if it is configured wrong in the back end?

Perplexed currently...
IT Solutions Engineer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Matt PinkstonEnterprise Architect

Author

Commented:
thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.