3

Using SP Online trying to create a simple workflow that triggers on item creation (in list A) to create list items in 2 different lists (list B & list C). i know the workflow is triggering as the first list item is created (list B), however the second list item is not created (list C).

Does anyone have any experience with this or suggestions where i should look to resolve?

8
  • Please add some screen shots of your Workflow code Commented Oct 17, 2016 at 6:26
  • Have you found any errors in log Commented Oct 17, 2016 at 6:32
  • Ok thanks for suggesting the log. i havnt used that until now. The error message is: Coercion Failed: Unable to transform the input lookup data into the requested type.
    – cr1
    Commented Oct 17, 2016 at 6:39
  • are you using lookup column in workflow Commented Oct 17, 2016 at 6:48
  • please check my updated answer Commented Oct 17, 2016 at 6:57

1 Answer 1

3

enter image description here

In above screen shot, creating items in List B and list C on item when new list item created in list A.

  1. Use action Create item
  2. Add list name
  3. Add fields and values

    Updated Answer

That usually happens when you use an empty field and set it to be something other than a string. For example, when you use a lookup value you can use it as a string, a lookup id, or a lookup value. If that lookup hasn't been set, lookup id and lookup value will give you a coercion error.

Same with a people field - if you try to use it as a 'Display Name' in workflow and the field is empty, you get the error.

If you are using Lookup column filed in workflow. then create a variable, put the information from the "Look Up Column" action into the variable, check if the variable is null, and if it is null set it to some default value that you decide.

Ref Article

Your Answer

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

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