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 '13 at 14:51
  • is that possible? sorry im just new to sharepoint. May 6 '13 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 '13 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 '13 at 18:23
  • i've added a little representation of my lists. thanks for all the reply. May 7 '13 at 8:20

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, privacy policy and cookie policy

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