<div>
Hello,<br>this error points usually to a type conversion error and happens usually if you point to an empty field. <br>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. &nbsp;<br>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.&nbsp; &nbsp;
</div>


<div>
The workflow has no issues creating the list item if I choose any of the original 161 facilities. &nbsp;When I add new facilities it will not work when I select those. &nbsp;So why is it having this issue with the new facilities but not the others?
</div>


SharePoint Data Program Analyst

Eldrick Vance

<div>
Thank You. After reading over your last comment &nbsp;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.&nbsp;
</div>


<div>
<div class="content wysiwyg-content fr-view">
SharePoint error: Coercion Failed: Unable to transform the input lookup data into the requested type. &nbsp;I have a Facilities list where it holds the facility info (name, ID, managers). &nbsp;I have a maintenance request list that uses the Facilities list &nbsp;to select the facility. When you submit a pre-request it should create a request in the actual request list. &nbsp;It works when selecting for the first 160 facilities but not for any new facilities added. &nbsp;The workflow cancels with the Coercion Failed error. &nbsp;Is this a lookup limit issue?
</div>
</div>



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?

SharePoint error: Coercion Failed: Unable to transform the input lookup data into the requested type

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.