I have a workflow which has, as the final step, a Create New List Item control, which fails, causing a fatal error, about 95% of the time. The error message is Coercion Failed: Unable to transform the input lookup data into the requested type. The purpose of this Create Item task, is to record the approval history, so that when the workflow activity purges from the list item, the approval history can be easily read from a Multiple lines of text (MLT) list column, rather than going to the workflow history list, and finding the associated line items with the item ID. In my create item control, I am including the Title from the context item, the Item ID from the context item, and the All Approvers' Comments from the Workflow Context data. I am certain that the point of failure is the All Approvers' Comments, writing to the MLT field. The MLT field set up is in attached image, although I have attempted to change the type of text to Plain Text, and still have the failure.
I have another workflow, which is running against a library, as opposed to a list, in which I update an MLT column on the item, against which, the workflow is running, with the All Approvers' Comments, and which consistently works without failure. But the Multiple Lines of Text setup options are different for Document Libraries and Lists, so I can’t determine why the one in the document library works consistently, without failure, while the one in the List fails fairly consistently.
As a side note, I went to the separate approval list, because I attempted to update the All Approvers' comments in a MLT field on my context list item, but it failed every time, (with this error: The workflow could not update the item, possibly because one or more columns for the item require a different type of information), where the create new item action worked for a while.
Would appreciate any assistance.