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

Copy Metadata

Jump to solution

HI, 

 

i need some help in copying metadata from one column to another. I have 3 single line of text columns and would like the metadata of them to be copied to 2 choice columns and one lookup column. The values do match in both types of column. 

Supplier Name: Single line of Text

Location: Single Line of Text

Category: single Line of Text

Supplier Name.: Lookup

Location0:Choice

Category.:Choice

Kammasood_0-1600169440277.png

 

Kammasood_1-1600169469034.png

 

Kammasood_2-1600169497194.png

The error i get is: 

Coercion Failed: Unable to transform the input lookup data into the requested type.

please advise?

 

Thanks 

Kam

Labels: (1)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Copy Metadata

Jump to solution

Hi,

 

The Coercion error occurs because you are trying to update a loopup column which is expecting a number with a string from the single lines of text column.

 

The correct way to do it is to find out what the number is of the lookup and update the column with that.

It would look something like below.

What it is doing is updating a lookup column on the current list by looking up the list containing the lookups.  Its looking for the item ID of the lookup item that equals the Single lines of text column in the current item and then updating the lookup column with an ID.

 

updateItem.png

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Copy Metadata

Jump to solution

Thanks, it has worked on the list workflow but how can i make it work on the site workflow. 

 

Kammasood_0-1600270807303.png

does it make sense?

 

thanks 

0 Kudos
Reply