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.