I am using a workflow where I need the value of a lookup field,
My current result is :
It needs to be:
Is there a way to take only the value using SharePoint Designer or I need to do the workflow from the Visual Studio?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
I guess you can use
Split action on workflow. Using
Split action you can split the string. In your case separator should be
I found following details from here.
After clicking around in SPD, I found a solution to the problem.
SharePoint Designer 2013 gives you the option to choose only the value of a lookup field. There is a dropdown menu which asks you what type of data you want to be returned. You need to choose Lookup Value (as Text) and you will take only the value of the lookup field, without id and the additional symbols.