Simple way to filter select list based on partial search

Sherazad Ahmed 411 Reputation points
2021-11-15T19:12:40.43+00:00

Hello,

I am trying to find a simple way to populate a select list on a form by the user typing in a partial search and those items being retrieved from a separate list and populated on the form.

I do not want to make the select list a lookup column because of the volume of data on the second list. Its approx 4500 items right now.

This is SharePoint 2016 on prem.

Microsoft 365 and Office SharePoint Development
{count} votes

Accepted answer
  1. Sherazad Ahmed 411 Reputation points
    2021-11-22T13:24:13.807+00:00

    Thanks Echo. Yes, it worked.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Echo Du_MSFT 17,316 Reputation points
    2021-11-16T07:53:08.727+00:00

    Hello @Sherazad Ahmed ,

    Please follow the steps:

    1.This is my ListA: WordList

    149667-1.jpg

    2.This is my ListB: TestList and create a "Single line of text" column named [TestColumn]

    149703-2.jpg

    3.On the ListB page, click From Web Parts >> Default New Form

    149668-3.jpg

    4.On the Edit New Form page, click "Add a Web Park" link to add the Script Editor web part

    149712-4.jpg

    5.On the Script Editor web part, click "EDIT SNIPPET" link

    149721-5.jpg

    6.Paste the below jQuery code:TestjQuery.txt

    149669-6.jpg

    7.Click "Stop Editing" to save page

    149722-7.jpg

    9.On the ListB page, click From Web Parts >> Default Edit Form

    149731-8.jpg

    10.For the next steps, please refer to the 4th, 5th, 6th and 7th

    Here is my test:

    149714-testlist.gif

    Thanks,
    Echo Du

    =========================================

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.