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.
Solved! Go to Solution.
since Location field is lookup field, you have to set it to ID value of respective location record from list B.
does your source excel provides you with these/correct IDs?
if not, you will have to configure create item action so the it looks up the ID in list B based on location column from source excel.