I need to make my custom list items distinct that's being used for a dropdown lookup. Please help. Here's the scenario. I have 2 lists, the list1 have a workflow that copies an item into my list2. This happens whenever the user creates a new record in list1. Now, the problem is that I need to set up a duplicate check somewhere to ensure that list2 items are distinct or unique. I'm thinking if there's a way in sp2007 to loop through list items to check if my new item is already exists.

Below are my two lists. When the user creates new critical maitenance activity in list1 there's a workflow that copies the criticalmaintenace activity field automatically into my list2. Now if you can see the 2nd list, you'll notice that there's a duplicate items. I need to find a way to make the 2nd list unique because I'm using it as a dropdown lookup in other list.

Maintenance Activity (List1) NewForm

Activity : "activity1"

ACtivities (List2) (DispForm)





  • Why don't you just make the lookup field unique? Is the workflow really necessary?
    – Hinek
    May 6, 2013 at 14:51
  • is that possible? sorry im just new to sharepoint. May 6, 2013 at 15:14
  • the lookup field is being populated with values from list1 when the user creates a new record. I have a workflow that copies item into my second list(lookup) automatically. May 6, 2013 at 15:21
  • Could you explain what you are doing a little better? Perhaps add some graphics? I suspect there may be a better way to achieve your desired functionality. May 6, 2013 at 18:23
  • i've added a little representation of my lists. thanks for all the reply. May 7, 2013 at 8:20

1 Answer 1


Assuming you mean that list1 CREATES an item in list2 (rather than copy) In Sharepoint deisgner workflow.. in the Create New List Item dialog box there is an option to "Overwrite the Existing File"... this may do it for you.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.