Trying to update item in Lookup column and getting error

  • 11 November 2016
  • 2 replies
  • 1 view
S
Badge +6

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

2 replies

E
Userlevel 5
Badge +14

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.

S
Badge +6

Thanks Marian,

Your suggestion solved my problem and I forgot to mark it as answered.  

Giving below setup I did, it may help others:

200051_pastedImage_1.png

Thanks

Sunil

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings