Scenario:
When trying to set a lookup field value in a sharepoint designer workflow you get this error:
Coercion Failed: Unable to transform the input lookup data into the requested type.
Background:
In a sharepoint blog site I wanted to add the post category field to the comments list in a column called PostCategory (lookup on categories). I chose to use a workflow for this task. The workflow is triggered on item creation and update.
Here is the simple worklfow I have created:
The key is the "Return field as" field in the last dialogue box. I was getting the Coercion Failed error when setting the field type as integer. Setting it to lookup id (as integer) solved the problem.
what type of field is Post Id as I don't get the option to select the Return field as value
Thanks for the post. It encouraged me to experiment. I found that setting a Metadata column with a workflow Variable:substring is possible if one sets the Return Field Value as a User Id Number.
this is exactly the issue I'm having except with a text field. I'm exhausted trying all the various options - it just plain won't accept my lookup field.