cancel
Showing results for 
Search instead for 
Did you mean: 
dougyk23
Nintex Newbie

Copy calculated field text to a lookup column with matching text

Jump to solution

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!

Labels: (1)
0 Kudos
Reply
2 Replies
Automation Master
Automation Master

Re: Copy calculated field text to a lookup column with matching text

Jump 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.

‌ set lookup field by other field‌

Reply
dougyk23
Nintex Newbie

Re: Copy calculated field text to a lookup column with matching text

Jump to solution

Awesome! Worked like a charm, thank you so much!

Reply