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.