I'm generating a reference number in a custom list in sharepoint designer. The process then waits for that to be set and copies the reference number across to a new entry in a tasks list.
The reference number in the custom list is of type 'single line of text' and is the title column in the list. In the tasks list the field is a lookup field but fails to take the reference across and gives:
Coercion Failed: Unable to transform the input lookup data into the requested type.
Has anyone had any experience with this issue on workflow