Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Remove Duplicates From Lookup Column

  Asked By: Anushka    Date: Jan 28    Category: Sharepoint    Views: 6504

Does anyone know how to remove duplicates from a lookup column
I am using a contacts list as a lookup and need to use company as the
column but since there is more than one contact for a company
the company shows up multiple times.



4 Answers Found

Answer #1    Answered By: Gwendolyn Acosta     Answered On: Jan 28

Has anyone got an answer i have posted this several times  without any
help what so ever

Answer #2    Answered By: Kyle Hernandez     Answered On: Jan 28

Filtered lookups are not available out of the box. You could duplicate
the data, otherwise you will need to create a Custom Field Type. This is
on my TODO list.

Answer #3    Answered By: Kedar Phule     Answered On: Jan 28

Re: You could duplicate the data

This is easy to do with a custom SDP workflow activity ...as one approach.

Answer #4    Answered By: Chanel Gaines     Answered On: Jan 28

To the best of my knowledge there is no way out of the box to remove
duplicates from a lookup  column. I suspect that the silence means that no
one else has found an answer for this either. Probably the only solution
would be to write an event handler that copied list  items to a second list
whenever an item was inserted updated or deleted. That event handler would
check each entry for uniqueness before copying it. The second list would
then become a unique lookup table for the item you wanted. I understand
that is less than elegant, but it's the only way I know of to do it.

Didn't find what you were looking for? Find more on Remove Duplicates From Lookup Column Or get search suggestion and latest updates.