Contents
The description is useful for us – Coercion Failed: Unable to transform the input lookup data into the requested type. This happens when you use a Lookup site column in workflow and the value is BLANK/NULL. The workflow fails when transforming the Lookup data ( blank in this case) into Lookup Value (as Text).
You should confirm that the Return Field As operation in their lookup is of the correct data type. This indicates there is an error in the workflow logic. Check to ensure that you are selecting the correct list and field in your lookup. This indicates there is an error in the workflow logic.
Why does my workflow fail the first time?
I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here’s how the data looks: Why would it work once and then fail? I have isolated this as the issue because if I hard code a Plant Title it works every time.
What does a data type error in workflow mean?
There is a data type error wherein the workflow is trying to set a value in a field in the list item using the wrong data type. You should confirm that the Return Field As operation in their lookup is of the correct data type. This indicates there is an error in the workflow logic.
SharePoint Designer Workflow problem with Lookup column There is a particular scenario in which you might receive the below error if using SharePoint Designer List Workflow. Coercion Failed: Unable to transform the input lookup data into the requested type.
Modify the workflow by adding an if condition to check if the Lookup value is not-empty (is not empty). Add further stages after the if condition. Add an else condition if required. After modifying the workflow this way, even null/empty/blank lookup values will be converted to a blank string value.