Ok first time asking a question here, hope it makes sense.I've been racking my brain how to do this using nintex workflows or any other option.
I have a list that has a calculated column called 'NewSetup'. I have another lookup column in the same list called 'NewSetup_lkup'. This lookup column points to a list that has a list of values that will match to the value of the calculated column.
I want to copy the calculated value in 'NewSetup' to the lookup column 'NewSetup_lkup' that has the same text value as 'NewSetup'.
I realize lookup columns use IDs instead of text, that's where i'm stuck. Not sure how to update a lookup value using text to match that up with the ID of the lookup list.
Any guidance/recommendations appreciated!
Solved! Go to Solution.
with list workflow you can do it with (eg) update item action configured like following
this updates value of NewSetup_lkup field of current item (one which workflow is running on) with ID of item from referenced lookup list (lkp1 in my example) for which value of (eg) Title field matches value of NewSetup field from current item.