Set Value in a lookup column to mirror another column

[itteam_rondo]

Hi All,

I am trying to set the value of a lookup column using the value of another field in the same list (don't really want to get bogged down in the reasons why).

I am trying to achieve this using the set field action and I have tried list lookups at the current item and many variations of using variables with not much success. When the workflow goes through it just sets the value like the below (The left column is a number and the right column is a lookup from another list)

This should be the same number.

your suggestions would be much appreciated.

Thank you.

[SimonMuntz]

Hi,

I'm guessing that item ID 242 on the lookup list has the value of 79.

[itteam_rondo]

Unfortunately No...

The ID of the current list item is the number on the left: 508

The ID of the list item on the other list is: 405

I have tried this

I have also tried it with variables

[SimonMuntz]

For testing if you try and set it as 405;#242 does it set correctly?

[itteam_rondo]

How would I do this sorry?

[itteam_rondo]

I think that I need to explain this issue a little further... 

Using the "fn-GetQueryString" function in Nintex Forms I am able to pass the RFC number into the new item form number column; 

Unfortunately you can not use the same function to populate a Lookup Column, we require a lookup column because we require the "Count Related" for the source list so we can get the below count. 

I have resorted to Nintex to copy the number that is populated automatically via  "fn-GetQueryString" to the Lookup column... this is resulting in the below examples;