I am using a workflow where I need the value of a lookup field,

  • My current result is : 210;#AA8888AA

  • It needs to be: AA8888AA

Is there a way to take only the value using SharePoint Designer or I need to do the workflow from the Visual Studio?

  • What version of SharePoint are you using? Not all features are available in all SPD versions.
    – Kalea
    Jul 24, 2017 at 19:50
  • SPD 2013, I found there is a option to take it only by value. When u are giving the field which you want to be return, there is a dropdown where you need to choose Lookup Value (as Text) and it will return you only the value :) Jul 25, 2017 at 6:23

2 Answers 2


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.

enter image description here

  • 1
    This way it's working too, but I managed to find a really simple solution, which I have added. Your answer is really helpful and can be used in many situations. Jul 25, 2017 at 6:32

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.

  • Really great outcome !!!! Jul 25, 2017 at 6:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.