Forum Discussion
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...
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.
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.