Forum Discussion
Eddoria
Jan 16, 2022Brass Contributor
SharePoint Online list filtering not display results
I have a SPO list with around 2000 items. There are around 50 columns. The issue we are facing is that certain columns can be filtered but even though there is a record nothing is displayed using the...
Alan_Gnegy
Jul 19, 2022Copper Contributor
Guys - I just determined that in our case, the filtering issue we are discussing here is related to a leading space in the value being filtered. So instead of the job number being "464870" it's actually stored in the List column as " 464870". When the filter gets applied, it's dropping the leading space, resulting in no items being shown.
Not sure if it's the same issue for you guys, but check for leading or trailing spaces.
Not sure if it's the same issue for you guys, but check for leading or trailing spaces.
mgaztr
Mar 14, 2023Copper Contributor
I was filtering over a calculated column having custom date format. I found that sharepoint list filter has some issues with underscore '_' character. When I removed it from column format in formula, filter worked.