I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks:

Look Up

 Title     Contacts
-------   ----------
 Plant1    John Smith; Jane Smith
 Plant2    John Doe; Jane Doe

Workflow List

 Title    Desc    Plant
-------  ------  -------
Test 1    asdf    Plant1

In the workflow, the plant contacts are found like this:

 Retrieve Data
 Plants -> Contacts as Email Semicolon Delimited

 Find Data
 Plants:Title = CurrentItem:Plant

Why would it work once and then fail? I have isolated this as the issue because if I hard code a Plant Title it works every time.

  • Is it failing the second time for the same list item? – Amal Hashim Jan 28 '15 at 21:44
  • The workflow is initiated by item creation. If I create the 2nd item with the exact same values, it will fail. – ExceptionLimeCat Jan 28 '15 at 22:54
  • So can we isolate this issue saying if duplicate items are created the workflow fails? – Amal Hashim Jan 28 '15 at 23:02
  • The issue is assigning a task using the associative value. If I do the same process but send an email instead; it works everytime. It doesn't matter if it's a Approval Process or Custom task both fail after first time. – ExceptionLimeCat Jan 30 '15 at 20:12
  • Correction looks like the WF intermittently fails even on the email action. – ExceptionLimeCat Jan 30 '15 at 20:21

To solve this issue just add wait until the look up value not empty in the start of the workflow preferred to be the first line :) Hope it help

enter image description here

  • Can you please improve your answer, with some more brief description. One liner may not be helpful for other visitors. – Asad Refai Sep 30 '15 at 13:35

Add Required field to Look up field. Or Minimum we need to select one value for Lookup Field. Then it won't show error.

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.