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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,839)