Hi all

I am having an issue with the "Create item" action in a workflow. Here is my scenario:

- 2 lookup lists "LookupRegion" and "LookupCountry"

- My source list "EntityApproval"

- My destination list "LookupEntity"

- When a new item is created (and approved) in "EntityApproval" the workflow replicates the item in "LookupEntity"

- "Region" and "Country" fields are lookup values from their respective lists and are common to both source and destination lists (i.e. the fields in both lists point to the same lookup lists).

When the workflow fails I get the error "Coercion Failed: Unable to transform the input lookup data into the requested type". I have identified the lookup fields as the problem (I've run the workflow with these omitted and it completes successfully).

Within the Create item action I am using List Lookup > Source: Current item > Field: Region/Country treturn type As Integer (Default)] to set the new item field value. It seems the workflow is taking the lookup text value though and that is where the coercion error is coming from.

I am a bit stumped from here so any assistance would be greatly appreciated!

Cheers

Rob