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

Move Lookup Column To Text Column

Jump to solution

This issue is really getting on my nerves because it makes no sense at all!!!!! I am using Nintex Workflow and SharePoint 2013. This should be a simple thing but as always simple things never turn out simple.

I have some columns in a list that are copied to a list in another site based on certain circumstances. One of those columns is a lookup. It worked fine. Well I needed another lookup column copied to that same list in the other site. This should be simple because it is currently working I just need this other one to do the same thing. Now in the source list it is a lookup and the target list is a string/text. Again, there is no problem with the one lookup. When I try to make the other column do the same thing it doesn't work. I get an error message that says something "Coercion Failed: Unable to transform the input lookup data into the requested type". Keep in mind, it wasn't doing it with the other lookup and I have it working the same way. I even have it doing it the same way in the "Create item in another site" action. I even went to another area where I play and test things. I made a lookup value copy to a text/string in another list - no error!!!! Someone please tell me what's wrong with this thing before I get a sledge hammer!!! Smiley Surprised

0 Kudos
Reply
21 Replies
Automation Master
Automation Master

Re: Move Lookup Column To Text Column

Jump to solution

Hi Lisa,

Are you saving the value of the lookup column in a variable or directly saving it to the other list? What action are you using to save to other list in another site? Is it possible that the value being passed is the ID of the lookup field and not the text itself?

If you set this value to a variable, do something like this:

Set Variable = varText, Equals List Lookup, Source: Current Item, Field: <your lookup field>, click on ..., Lookup value (as text)

Did you already use the sledge hammer?

Reply
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

Just as the previous code was retrieving the value from the lookup and passing it that was all I did. I did not save it to a variable. "Create item in another site" was the action I used. I even created a string variable and saved it there before copying it. I used a string builder before copying it just to make sure. It didn't work regardless of the method. I got the same error. I even did a log history to check the value and it came up as a string not a ID/number.

Reply
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

Oh I haven't used the sledge hammer yet but it is definitely on stand by!!!!!

Reply
Automation Master
Automation Master

Re: Move Lookup Column To Text Column

Jump to solution

Good News: I was able to replicate your issue.

Better News: It worked for me by saving the lookup value to a "Single line text" variable as Lookup value (as Text) and then using this variable in the "Create item in another site" action.

You mentioned that you have already tried this way correct?

Reply
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

I'm going to try your suggestion in the morning. But it still doesn't make sense that the other lookup works when I'm doing it the same way.

0 Kudos
Reply
Highlighted
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

SEEEEEEEEE.....I knew I wasn't crazy! I just don't understand why the other lookup works. I didn't use a 'Set Variable' action. I simply put it in the 'Create Item In Another Site' action and selected the variable. What do  you mean by 'DocsCodes - Lookup Value (as Text)'?

Reply
Automation Master
Automation Master

Re: Move Lookup Column To Text Column

Jump to solution

I selected the field DocsCodes and then clicked on (...) next to it and select Lookup Value as Text option.

Reply
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

I am still getting the same error.

Reply
burkslm
Nintex Newbie

Re: Move Lookup Column To Text Column

Jump to solution

The second field set as a value is an actual lookup field too that was working prior to me trying to get my FY field to work. I had imitated that to no avail!!!

0 Kudos
Reply