Set Value in a lookup column to mirror another column

  • 28 July 2020
  • 5 replies
  • 16 views
I
Badge +3

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)

 

8502iD6F3B6157A031F9A.png

 

This should be the same number.

 

your suggestions would be much appreciated.

 

Thank you.

5 replies

SimonMuntz
Userlevel 6
Badge +22
Hi,

I'm guessing that item ID 242 on the lookup list has the value of 79.
Cool Nintex courses: https://learn.nintex.com/
I
Badge +3

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

 

8504i4C83BC94D667265D.png

I have also tried it with variables

 

8505iB7630A4D3A484C64.png

 

8506i2B2CE8E9F0D1B3AF.png

 

SimonMuntz
Userlevel 6
Badge +22
For testing if you try and set it as 405;#242 does it set correctly?
Cool Nintex courses: https://learn.nintex.com/
I
Badge +3

How would I do this sorry?

I
Badge +3

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; 

8520iFD2EF458370CB1E5.png

 

8519i121DB08AF5094004.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. 

 

8522i2A509179E931AA54.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;

 

 

8521iB39C9F038B44DD96.png

 

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings