OK so this has stumped me. So I have a query that sets some string variables based on an ID. The query runs fine if I execute on the spot but many of the fields I am returning are not populated. I didn't expect that to be an issue.
The object of this workflow is to copy data from one table to a table in another site- however the fields are all optional so some may be blank and I need to work with that. I am however getting a Coercion Failed: Unable to transform the input lookup data into the requested type in the Create Item in Another Site. There are 50+ fields I am working with so creating a Create Item in Another Site based on which fields have data is just not possible as there are too many combinations. This error occurs even if I am only populating one field (which is a text field and has data).
All the fields are either date, text or choice fields. I want to leave the date fields blank if they are blank in the original data so I hate to have to populate them if that is the issue. However I even created a blank list with only one text field (that has a text value) and even that fails with the Coercion error.
So Now in my blank list I created a workflow that just puts text values into the list. Even though when creating the action it lets me select the list and fields when it runs it gives me the error Unable to find list to create an item in.
ETA: Updated to reflect further testing which revealed a different issue.