cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoannaLegowska
Frequent Visitor

Bug in Lookup?

Hello comunity,

 

I have a form for a SharePoint list (List1), where one of the filed is a lookup to another SP list (List2). 

It can happen, that the items on the List2 have the same value in "Name" field (lookup on the List1 is referring to this field). 

 

Example:

I have 2 items with the same "Name": 

JoannaLegowska_5-1622624493598.png

 

I choose the 1st one. After that I want to change it to the second item and here starts the problem.

 

Problem:

I choose the 1st item, then I want to change it to the 2nd one, both are automatically highlighted on the dropdown list:

JoannaLegowska_4-1622624444292.png

 

 

When I choose the 2nd item, the value of the field will be completely reset:

 

JoannaLegowska_3-1622624323437.png

 

 

It doesn't happen, when I choose on the dropdown items with different Names (so e.g. Test and Test1).

 

Thank you in advance for your help!

 

2 REPLIES 2
zmansuri
Super User
Super User

It's not best practice to let user choose from values which looks same. when lookup fields are involved. You will get wrong data. better come up with something unique.

For sure, but unfortunately it is a requirement from the customer and we cannot change it.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,192)