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?