I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for the list "customers", which creates an "expense sheet" item, which has the lookup field filled with the current item in the "customers" list, from which I start the workflow. Unfortunately, this always creates an error.

Another field type in the "expense sheet" list would not work for me as I Need the special connection created by a lookup field.

Could someone please help me?

  • What is the error message ? What are you assigning as the value for the lookup ? – JayHell Apr 25 '16 at 18:26
  • The error is: "Coercion Failed: Unable to transform the input lookup data into the requested type." – Lukas Reiners Apr 25 '16 at 18:33
  • the lookup in the list "expense sheet" refers to the field title in the list "customers". – Lukas Reiners Apr 25 '16 at 18:34
  • in the workflow I try to use the value for the related customer: "current item: title" – Lukas Reiners Apr 25 '16 at 18:35
  • 1
    Try the ID instead of the title. – JayHell Apr 25 '16 at 18:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.