Forum Discussion
ViniRamosSilva
Apr 26, 2023Copper Contributor
"Filter by" on Sharepoint brings zero results but item is on the list (when theres a space at end)
Hello, One thing that's really a bummer when using the "Filter By" on a sharepoint list column is that it only filters for exact string matches. So for example, if a have a column for NAME, ...
ViniRamosSilva
May 26, 2023Copper Contributor
up
suvi-15
May 26, 2023Brass Contributor
ViniRamosSilva since it is Text column so space is allowed, either when user enter data probably you can put validation check( Validation settings- =ISERROR(FIND(" ",[column Name]))) for space. This will stop user to put unnecessary extra space at the end or before.