question

JamesPhilbey-0954 avatar image
0 Votes"
JamesPhilbey-0954 asked ElsieLu-MSFT commented

Sharepoint Library Column Filter contains rather than begins with

Hi,

I have a sharepoint library that has a field called bank which is a choice column that you can select banks that the document relates too. When adding the banks if I start typing it will show banks that start with the text being typed but not that maybe part of a second word. For example say the I want to get 'Bank of England' if I start typing 'Bank..' it will show but if I type 'England' it will not.
Can I edit the settings so that it shows choices containing the text for normal users.

105335-image.png
105349-image.png

Thanks for help


office-sharepoint-online
image.png (20.1 KiB)
image.png (21.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi James

Your question appeared not related to Open Specifications Protocols outline here https://aka.ms/openspecs, I am removing following tag [openspecs-office-sharepoint]


0 Votes 0 ·

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT commented

Hi @JamesPhilbey-0954 , welcome to Q&A forum!

Per my knowledge, the Choice column in SPO currently only supports "Begin with" search. We understand your situation, however this is the default behavior of SPO, I might have to say there is currently no setting to change this default behavior.

Thanks for your support and understanding. :)


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JamesPhilbey-0954 ,

How are things going? Is there any update?
If you think my suggestion is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum. Also others will directly see the answer.

Thanks,
Elsie Lu

0 Votes 0 ·