Copy Metadata

Forum|Forum|5 years ago
September 15, 2020
2 replies
18 views

+3

Kammasood
Rookie

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

The error i get is:

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

please advise?

Thanks

Kam

+23

Simon Muntz
Nintex Partner
Forum|Forum|5 years ago
September 16, 2020

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.