Sharepoint Library Column Filter contains rather than begins with

James Philbey 1 Reputation point
2021-06-14T10:38:10.57+00:00

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

Microsoft 365 and Office SharePoint For business Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Elsie Lu_MSFT 9,801 Reputation points
    2021-06-15T05:49:05.107+00:00

    Hi @James Philbey , 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.