1

I have created a workflow that checks if an item exist in another list (List B). The first thing it does is to add an unique ID to the item, if it is a new item. If I am updating an item, the workflow will use this ID to check if the item exists in another list. For this I have created a Variable (Project ID).

I have inserted a condition saying "If List B: Project ID equals Variable: Project ID" (Find the List item field is set to Field Project ID, Value: Variable: Project ID)

This should tricker an action: "Log [%Current Item:Project Number%] already exists in List B", but it doesn't work.

However if I replace the definisions with Title, it works. But if I replace it with Project nr it goes back to not working

(in both cases I haven't changed the Find the List item)

I have added a picture of my workflow below.

enter image description here

  • what are the types of the variable(ProjectID) and the field (RW-NC:ProjectID) ? – A.Saéed Mar 5 '18 at 15:55
  • Variable(ProjectID) takes the default ID generated by SharePoint and puts a "ID" in front - i.e. ID1234. And the RW-NC:ProjectID is a textfield. – Maria Rey - SharePoint Mar 7 '18 at 8:21
  • If I, instead of using ID+generated ID, use the Title field, it works. Why? – Maria Rey - SharePoint Mar 7 '18 at 8:44
2

1- Instead of setting the variable ProjectID to the current Items ID field,
set the ProjectID variable to the projectID in the other list, using Find the list Item by setting the ProjectID on the other list with the ProjectID of the Current Item.

enter image description here

2- then check IF the variable is Empty, if not empty means the item is exists.

enter image description here

0

And now it doesn't work again. I have deleted the workflow and started over. It seems to be another field that is causing the problem.

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.