SOLVED
Home

SharePoint List View Filter Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1127566%22%20slang%3D%22en-US%22%3ESharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1127566%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20bit%20of%20a%20strange%20issue.%20I%20migrated%20a%20list%20with%20over%2015000%20items%20from%20SharePoint%202007%20to%20SharePoint%20Online.%20The%20default%20view%20is%20exactly%20the%20same%20and%20has%20the%20same%20filters.%20It%20should%20be%20displaying%20944%20items%20(as%20it%20is%20in%20SharePoint%202007)%2C%20however%20on%20SharePoint%20Online%20I%20am%20getting%20this%20error%20message%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167034i4F38B11159B4F49B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22view%20error.PNG%22%20title%3D%22view%20error.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20SharePoint%202007%20view%20and%20filters%20are%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20519px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167036iAFC3A66B259244EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sp2007%20view.PNG%22%20title%3D%22sp2007%20view.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167037i733DD3E0A43579FB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sp2007%20view%20filter.PNG%22%20title%3D%22sp2007%20view%20filter.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20SharePoint%20Online%20view%20is%20configured%20exactly%20the%20same%20(as%20per%20the%20below)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20746px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167039i85AC66C7FED5B8B1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sp%20online%20view%20filter.PNG%22%20title%3D%22sp%20online%20view%20filter.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EA%20third%20party%20tool%20(ShareGate)%20is%20saying%20that%20this%20view%20is%20only%20returning%20944%20items%20on%20SharePoint%20Online%20so%20am%20not%20sure%20why%20I%20am%20getting%20that%20error%20message%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1127566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129965%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129965%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20adding%20%22Index%20Columns%22%20to%20the%20list.%20The%20columns%20used%20in%20the%20view%20filters%20would%20be%20ideal.%20More%20information%20located%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmanage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmanage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130201%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130201%22%20slang%3D%22en-US%22%3EAgree%20here%20with%20Norman%2C%20best%20you%20can%20do%20is%20try%20to%20solve%20the%20issue%20by%20adding%20indexes%20to%20the%20list%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130847%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B-%20thank%20you%20both.%20I%20have%20created%20the%20indexes%20on%20the%20filtered%20columns%2C%20along%20with%20the%20automatically%20created%20indexes%2C%20but%20unfortunately%20am%20still%20getting%20the%20same%20error%20message%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167454iAF297964FA6327BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22index.PNG%22%20title%3D%22index.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20498px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167455i3E0970093FB56191%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22index2.PNG%22%20title%3D%22index2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167456i847F9C4523DA2AD0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22error.PNG%22%20title%3D%22error.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130964%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130964%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20try%20the%20steps%20outlined%20in%20the%20section%20%22Edit%20the%20list%20view%22%3F%20I%20know%20it%20will%20not%20be%20the%20desired%20user%20experience%20but%20I%20believe%20these%20are%20the%20only%20options%20you%20will%20have%20in%20SharePoint%20Online.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130969%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130969%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20but%20yes%20I%20have%20and%20unfortunately%20it%20is%20still%20not%20working.%20I%20have%20removed%20all%20sorting%2C%20grouping%2C%20totals%20and%20also%20deselected%20all%20columns%20in%20this%20view%20other%20than%20the%20Title%20column%2C%20but%20am%20still%20getting%20the%20same%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130974%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130974%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20unfortunate.%20Did%20you%20try%20filtering%20by%20%22Phase%22%20to%20get%20past%20the%20error%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20out%20of%20ideas%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3Bcan%20you%20think%20of%20anything%20further%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1131191%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20have%20and%20unfortunately%20still%20no%20joy!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20further%20troubleshooting%2C%20it%20appears%20to%20break%20(display%20the%20error%20message)%20as%20soon%20as%20you%20add%20more%20than%20one%20'OR'%20filter.%20I%20have%20tested%20this%20with%20a%20couple%20of%20items%20and%20using%20two%20filters%20so%20it%20should%20only%20return%20those%20two%20items%20I%20tested%20with%2C%20but%20I%20am%20still%20getting%20the%20error%20message.%20As%20soon%20as%20I%20just%20use%20one%20filter%2C%20it%20seems%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1131249%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131249%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20article%20might%20be%20worth%20reviewing%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fjoannecklein.com%2F2019%2F01%2F23%2Flist-view-threshold-error-watch-your-column-types%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjoannecklein.com%2F2019%2F01%2F23%2Flist-view-threshold-error-watch-your-column-types%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1150725%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1150725%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3Bbut%20unfortunately%20I%20am%20not%20sorting%2C%20filtering%20or%20grouping%20by%20any%20of%20these%20column%20types.%20I%20am%20currently%20in%20contact%20with%20Microsoft%20so%20hopefully%20can%20get%20a%20resolution%2Fworkaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1150844%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1150844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%20I%20hope%20support%20can%20help%20further.%20If%20possible%2C%20please%20share%20back%20the%20root%20cause%20and%20resolution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sam1209
Occasional Contributor

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:

view error.PNG

The SharePoint 2007 view and filters are below:

sp2007 view.PNGsp2007 view filter.PNG

 

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

 

sp online view filter.PNG

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? 

10 Replies
Highlighted
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

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

@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 index.PNGindex2.PNG

error.PNG

Highlighted

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

Highlighted

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.

Highlighted

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

Highlighted

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.

Highlighted

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

Highlighted

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.

Highlighted

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

 

Thanks.

 

Norm