Cannot show the value of the filter on list column

%3CLINGO-SUB%20id%3D%22lingo-sub-283823%22%20slang%3D%22en-US%22%3ECannot%20show%20the%20value%20of%20the%20filter%20on%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283823%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20SharePoint%20online%20we%20have%20a%20list%20with%20about%201500%20items%2C%20list%20has%20a%20infopath%20form%26nbsp%3Battached%20to%20it%2C%20No%20of%20items%20in%20the%20list%20is%20less%20than%20threshhold%20limit%20defined%20for%20online%20list.%20We%20can%20see%20all%20the%20items%20in%20the%20view%20but%20when%20try%20to%20use%20column%20filters%20in%20list%20view%20it%20gives%20errors%20out%20%22Cannot%20show%20the%20value%20of%20the%20filter.%20The%20field%20may%20not%20be%20filterable%2C%20or%20the%20number%20of%20items%20returned%20exceeds%20the%20list%20view%20threshold%20enforced%20by%20the%20administrator.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20googled%20but%20every%20one%20suggest%20list%20items%20limit%20but%20in%20this%20case%20the%20items%20are%20already%20under%20the%20limit.%20I%20tried%20to%20add%20index%20on%20the%20two%20columns%20which%20we%20are%20using%20in%20the%20view%2C%20tried%20to%20limit%20no%20of%20columns%20in%20the%20view%20%2C%20add%20filters%20to%20the%20view%20but%20nothing%20helped.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestion%20what%20else%20can%20be%20checked%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-283823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ethreshold%20limit%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284383%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20show%20the%20value%20of%20the%20filter%20on%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284383%22%20slang%3D%22en-US%22%3E%3CP%3EMost%20of%20the%20columns%20in%20the%20list%20are%20single%20line%20of%20text%2C%20Yes%20definately%20checked%20it%20total%20number%20of%20columns%20is%20less%20than%201500.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20errors%20on%20all%20the%20columns%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284052%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20show%20the%20value%20of%20the%20filter%20on%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284052%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20are%20the%20columns%20you%20are%20trying%20to%20filter%3F%20You%20don't%20by%20chance%20have%20like%20a%205000%20item%20drop%20down%20list%20or%20something%20do%20you%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20it%20do%20it%20with%20any%20column%20you%20try%20to%20filter%20on%20or%20just%20certain%20ones%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599901%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20show%20the%20value%20of%20the%20filter%20on%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599901%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42008%22%20target%3D%22_blank%22%3E%40Kanwar%20Jot%20Singh%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20also%20facing%20the%20same%20issue%2C%20were%20you%20able%20to%20fix%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

In SharePoint online we have a list with about 1500 items, list has a infopath form attached to it, No of items in the list is less than threshhold limit defined for online list. We can see all the items in the view but when try to use column filters in list view it gives errors out "Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator."

 

I have googled but every one suggest list items limit but in this case the items are already under the limit. I tried to add index on the two columns which we are using in the view, tried to limit no of columns in the view , add filters to the view but nothing helped. 

 

Any suggestion what else can be checked 

3 Replies
Highlighted

What are the columns you are trying to filter? You don't by chance have like a 5000 item drop down list or something do you? 

 

Does it do it with any column you try to filter on or just certain ones? 

Highlighted

Most of the columns in the list are single line of text, Yes definately checked it total number of columns is less than 1500. 

 

It errors on all the columns 

Highlighted

@Kanwar Jot Singh

 

I'm also facing the same issue, were you able to fix the issue?