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
The error i get is:
Coercion Failed: Unable to transform the input lookup data into the requested type.
Solved! Go to Solution.
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.