cancel
Showing results for 
Search instead for 
Did you mean: 
suniltamanekar
Nintex Newbie

Trying to update item in Lookup column and getting error

Jump to solution

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

0 Kudos
Reply
2 Replies
Automation Master
Automation Master

Re: Trying to update item in Lookup column and getting error

Jump 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.

Reply
suniltamanekar
Nintex Newbie

Re: Trying to update item in Lookup column and getting error

Jump to solution

Thanks Marian,

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

Giving below setup I did, it may help others:

Thanks

Sunil

View solution in original post

0 Kudos
Reply