SharePoint error: Coercion Failed: Unable to transform the input lookup data into the requested type
SharePoint error: Coercion Failed: Unable to transform the input lookup data into the requested type. I have a Facilities list where it holds the facility info (name, ID, managers). I have a maintenance request list that uses the Facilities list to select the facility. When you submit a pre-request it should create a request in the actual request list. It works when selecting for the first 160 facilities but not for any new facilities added. The workflow cancels with the Coercion Failed error. Is this a lookup limit issue?
ASKER
The workflow has no issues creating the list item if I choose any of the original 161 facilities. When I add new facilities it will not work when I select those. So why is it having this issue with the new facilities but not the others?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank You. After reading over your last comment a few times and then looking back at my Facilities list it was expecting a field not to be blank. Once I figured out that field and selected an answer it worked. Thanks again for your assistance.
this error points usually to a type conversion error and happens usually if you point to an empty field.
A general workaround is to use an IF statement to check the content of a value and use it only, if the content ist not empty.
To indentify possibly failing items, you may temporarily use the workflow-history as a log, where you can give aout the values of your variables you are reading inside the workflow.