AnsweredAssumed Answered

Trying to update item in Lookup column and getting error

Question asked by suniltamanekar on Nov 11, 2016
Latest reply on Feb 28, 2017 by suniltamanekar

Hi,

 

I have a List A having columns as

       Title       -      Single Line Text

       Name    -      Single Line Text

       Location  -    Lookup   (on List B)

I am trying to create items in List A through workflow by reading an excel file having three columns.  Title and Name are getting created correctly but nothing appears in Location column.  On checking log history it is found that intermediate workflow variable for Location have correct value.  Also the workflow throws an error "Coercion Failed: Unable to transform the input lookup data into the requested type.".

 

I appreciate response as I have to create the list A with 700 items.

 

Thanks

Sunil

Outcomes