I am trying to read a "
Lookup" Column called 'Color' from a list and simply copy it into another "Text" column called 'Scheme' through SharePoint Designer 2013.
In Designer, doing
- "Set Scheme to
CurrentItem:Color" does NOT work.
I also tried creating a 'String' Variable called 'SchemeVar' and did:
"Set Variable:SchemeVar to CurrentItem:Color
This also does not work. My workflow gets suspended.
My GOAL is to be able to use the Lookup field content in an email but it is not coming through for me. Any advice would be greatly appreciated!!
PS: In designer, my Lookup field's "
Return field as" is 'Lookup Value (as Text)' and can not be changed.