Skip to main content

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


8937i0B13F4DE7F765FCB.png


 


8938i4AB96D0E3C4602C8.png


 


8939i7CE21259BB143890.png


The error i get is: 




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

please advise?


 


Thanks 


Kam

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.


 


8952iFDE059850FEA3A7E.png

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


 


8966i63C21BA5588750A2.png


does it make sense?


 


thanks 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings