How to manage lookup fields in list form

Question

Hello,

I have one list "Test" which have few lookup fields such as "Customer Number" and "Customer Name"  from another list "Customer".

Customer list contains records more than 5000 ( Crossing threshold)

So I want a search functionality for  "Customer Number" and "Customer Name" fields in "Test" list when user is entering new record.

Is it possible?

Please guide.

Thanking you in advance.

Regards,

Jayashri

Answer 1

Some question to you before we could help,

1. Win Form? Web Form? Razor? MVC? WPF?
2. How do you retrieve the data of Customer Number, Customer Name, and Customer? DataTable? DataSet?
3. What did you store the data of Customer Number, Customer Name, and Customer? DataTable? DataSet?

Answer 2

Thank you for your reply @Ken Kam Hung, Lin

I want to customize list form in simple way without Infopath or Power apps

I want to retrieve data from list : Customer whose reference has been added as Lookup column in "Test" list

Answer 3

Hi @Jayashri Thorat ,

Per my understanding, currently the lookup columns support the limit of more than 5000. I would suggest you consider reducing the number.

Here is a similar post for your reference:
Lookup column agains list with more than 5000 posts

And you could go to SharePoint UserVoice to make your suggestions:
Lookup on lists over 5,000

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

Test in my end:

Thanks for your understanding and support. :)

Have a nice day!

---

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.

Answer 4

Thank you for your reply.

We already have a list in on-premise version which is fetching values from Lookup column which have more than 5000 items.
I can't implement same Custom form in Online version..so need guidance how to do it Online.
Please find attached files( originally its with extension .js but as I cant attached it here so saved as .txt) which is working on On-premise version93263-customnewformposttext.txt93228-handlerposttext.txt