SOLVED

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%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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1372091%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372091%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Sam%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20get%20any%20update%20on%20this%20issue%20from%20Microsoft%20%3F%20I%20am%20having%20the%20same%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20re-creating%20views%2C%20deleting%20and%20re-creating%20index%20column%20for%20filter%20but%20seems%20nothing%20is%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3EMeena%20Makwana%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382624%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Filter%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382624%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563508%22%20target%3D%22_blank%22%3E%40Meena_Makwana%3C%2FA%3E%26nbsp%3B-%20unfortunately%20Microsoft%20came%20back%20with%20the%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23008000%22%3EI've%20got%20further%20feedback%20from%20the%20Product%20Group%20on%20this%20matter%2C%20after%20sharing%20all%20details%20all%20logs%20we%20gathered%20they%20have%20referred%20this%20is%20a%20by%20design%20situation%20for%20the%20Online%20platform.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23008000%22%3EAdding%20on%20the%20complexity%20of%20the%20filter%20will%20make%20the%20server%20side%20query%20have%20to%20look%20at%20more%20items%20on%20the%20list%20triggering%20the%20throttling%20for%20it%20independent%20of%20the%20number%20of%20items%20returned%20in%20the%20view%2C%20the%20list%20will%20have%20to%20process%20all%20its%20items%20in%20order%20to%20determine%20what%20should%20be%20returned%20or%20not%20on%20the%20list%20view%2C%20from%20the%20logging%20we%20were%20able%20to%20confirm%20the%20throttling%20is%20being%20set%20very%20early%20on%20the%20list%20access%20blocking%20the%20view%20from%20returning%20data%20due%20to%20the%20size%20of%20the%20list%20itself.%20On%20SharePoint%20Server%20this%20list%20view%20threshold%20can%20be%20changed%20but%20in%20the%20online%20platform%20it%20is%20implemented%20on%20the%20platform%20design%20and%20can't%20be%20altered%20from%205000%20items.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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? 

12 Replies
Highlighted
Best Response confirmed by Juan Carlos González Martín (MVP)
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

Highlighted

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

Highlighted

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.