itteam_rondo
Canvas Initiate

Set Value in a lookup column to mirror another column

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)

 

itteam_rondo_0-1595913636632.png

 

This should be the same number.

 

your suggestions would be much appreciated.

 

Thank you.

0 Kudos
Reply
5 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Set Value in a lookup column to mirror another column

Hi,

I'm guessing that item ID 242 on the lookup list has the value of 79.
0 Kudos
Reply
itteam_rondo
Canvas Initiate

Re: Set Value in a lookup column to mirror another column

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

 

itteam_rondo_0-1595915096404.png

I have also tried it with variables

 

itteam_rondo_1-1595915201776.png

 

itteam_rondo_2-1595915210818.png

 

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Set Value in a lookup column to mirror another column

For testing if you try and set it as 405;#242 does it set correctly?
0 Kudos
Reply
itteam_rondo
Canvas Initiate

Re: Set Value in a lookup column to mirror another column

How would I do this sorry?

0 Kudos
Reply
itteam_rondo
Canvas Initiate

Re: Set Value in a lookup column to mirror another column

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; 

itteam_rondo_2-1596004126754.png

 

itteam_rondo_1-1596004061515.png

 

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. 

 

itteam_rondo_0-1596004805474.png

 

 

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;

 

 

itteam_rondo_0-1596004643134.png

 

 

0 Kudos
Reply