SharePoint List View Filter Issue

[Sam1209]

I have a bit of a strange issue. I migrated a list with over 15000 items from SharePoint 2007 to SharePoint Online. The default view is exactly the same and has the same filters. It should be displaying 944 items (as it is in SharePoint 2007), however on SharePoint Online I am getting this error message:

The SharePoint 2007 view and filters are below:

The SharePoint Online view is configured exactly the same (as per the below):

A third party tool (ShareGate) is saying that this view is only returning 944 items on SharePoint Online so am not sure why I am getting that error message? 

[#2 · Accepted solution]

Hi @Sam1209,

Try adding "Index Columns" to the list. The columns used in the view filters would be ideal. More information located here: https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-938...

I hope this helps.

Norm

[#3]

Agree here with Norman, best you can do is try to solve the issue by adding indexes to the list

[#4]

@Norman Young @Juan Carlos González Martín - thank you both. I have created the indexes on the filtered columns, along with the automatically created indexes, but unfortunately am still getting the same error message:

@Norman Young 

[#5]

Hi @Sam1209,

Did you try the steps outlined in the section "Edit the list view"? I know it will not be the desired user experience but I believe these are the only options you will have in SharePoint Online. 

I hope this helps.

Norm

[#6]

Hi @Norman Young

Thank you but yes I have and unfortunately it is still not working. I have removed all sorting, grouping, totals and also deselected all columns in this view other than the Title column, but am still getting the same error.

[#7]

Hi @Sam1209,

That's unfortunate. Did you try filtering by "Phase" to get past the error?

I'm out of ideas, @Juan Carlos González Martín can you think of anything further?

Thanks.

Norm

[#8]

Hi @Norman Young 

Yes I have and unfortunately still no joy!

After further troubleshooting, it appears to break (display the error message) as soon as you add more than one 'OR' filter. I have tested this with a couple of items and using two filters so it should only return those two items I tested with, but I am still getting the error message. As soon as I just use one filter, it seems to work.

[#9]

Hi @Sam1209,

This article might be worth reviewing: https://joannecklein.com/2019/01/23/list-view-threshold-error-watch-your-column-types/

I hope this helps.

Norm

[#10]

Thanks @Norman Young but unfortunately I am not sorting, filtering or grouping by any of these column types. I am currently in contact with Microsoft so hopefully can get a resolution/workaround.

[#11]

Hi @Sam1209, I hope support can help further. If possible, please share back the root cause and resolution.

Thanks.

Norm

[#12]

Hello Sam, 

Did you get any update on this issue from Microsoft ? I am having the same issue.

I tried re-creating views, deleting and re-creating index column for filter but seems nothing is working.

Best Regards,

Meena Makwana

[#13]

Hi @Meena_Makwana - unfortunately Microsoft came back with the below:

I've got further feedback from the Product Group on this matter, after sharing all details all logs we gathered they have referred this is a by design situation for the Online platform.

Adding on the complexity of the filter will make the server side query have to look at more items on the list triggering the throttling for it independent of the number of items returned in the view, the list will have to process all its items in order to determine what should be returned or not on the list view, from the logging we were able to confirm the throttling is being set very early on the list access blocking the view from returning data due to the size of the list itself. On SharePoint Server this list view threshold can be changed but in the online platform it is implemented on the platform design and can't be altered from 5000 items.