Forum Discussion
SharePoint List View Filter Issue
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?
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-9387-48c2-9248-c24122f07c59?ui=en-US&rs=en-US&ad=US
I hope this helps.
Norm
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-9387-48c2-9248-c24122f07c59?ui=en-US&rs=en-US&ad=US
I hope this helps.
Norm
- Agree here with Norman, best you can do is try to solve the issue by adding indexes to the list
Norman Young jcgonzalezmartin - 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:
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
