How to set a lookup column to have unique values

Raj Shekar 21

How to set a lookup column to have unique values

Itch Sun-MSFT 2,556 Reputation points

2020-08-10T09:46:27.84+00:00

I am checking your situation here.
Any progress on your troubleshooting?
Itch Sun-MSFT 2,556 Reputation points

2020-08-13T09:06:02.95+00:00

Hi @Raj Shekar
This thread has been around for a long time. Please remember to accept them Answer if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thank you for understanding! If you have any questions, or updates, please feel free to let me know.
Itch Sun-MSFT 2,556 Reputation points

2020-09-11T02:33:45.363+00:00

Hi @Raj Shekar
Do you have any progress on this thread? If you find any reply helpful, please remember to accept it as answer.
It will help others who meet similar questions in this forum. Thank you for your understanding.

1 answer

Itch Sun-MSFT 2,556 Reputation points

2020-08-06T01:45:14.737+00:00

What mode do you use? Modern or classic?

There is no OOB method to enforce unique values in a lookup field. Also, currently, it is hard to insert code into modern experience.

You should switch to classic experience for this list. Then you can use code to set unique value for the lookup column. Just add the code into NewForm.aspx page.

You can refer to below article:

Removing Duplicate values from a Lookup field

Please note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer