asked on

Microsoft O365 SharePoint Limit

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?

Walter Curtis

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 Pinkston

ASKER

yes our filter is currently only showing 20 records which is why we are confused

Walter Curtis

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

Perplexed currently...

ASKER CERTIFIED SOLUTION

Greg Besso

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Matt Pinkston

ASKER

thanks