When I open the list form, others column appear but as there is more than 5000 items in one lookup column, so instead of select column it shows the message that it has crossed the threshold.

There is more than 5000 items in it, but if I remove the duplicates then I will get less then 100 items in it.

I have tried to remove the duplicate using JS but this doesn't work at all. I have one idea that I need to create one more list to have only unique value. It would be less then 100 item and then I can populate those in lookup column here.

Is there any other approach to do this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.