2

I am sending an email through workflow and would like to indicate the Approval status. For example, I want the email to look like this:

Your request has been Approved by the Administrator.

OR

Your request has been Rejected by the Administrator.

HOWEVER, the email outputs:

Your request has been 0;#Approved by the Administrator.

How can I remove the 0;#?

NOTE: I am aware I could create an email for each approval status, but I was hoping to do it in just one.

Thanks in advance!

Ryan

Improve this question
7
  • Can you screenshot and send how you are getting the Approval Status? There should be a "Type" that you can fetch to "Lookup Value" instead of by String.
    – Mike
    Jun 25 '13 at 21:23
  • Thanks Mike, I'm new here so I don't have the ability to add images yet. What I've done is created a workflow that sends an email. The email then contains the [%Request:Approval Status%] in the body. But it shows up as either 0;#Approved or 0;1Rejected. I am using SharePoint 2007 so I don't see a lookup value in my actions. Cheers!
    – Ryan George
    Jun 27 '13 at 16:08
  • You could have an IF/ELSE branch that says IF [%Request:Approval Status%] CONTAINS Approved set variable to "Approved" else set variable to "Rejected" and put that variable in the email body instead.
    – Mike
    Jun 27 '13 at 16:39
  • Thanks, but I was hoping there was a way to avoid maintaining two different emails with the only difference being one word.
    – Ryan George
    Jun 27 '13 at 17:25
  • ... OR you may be on to something... If I do that and then create another step that sends the email... I will test it and let you know. Thanks!
    – Ryan George
    Jun 27 '13 at 17:31
0

You could have an IF/ELSE branch that says IF [%Request:Approval Status%] CONTAINS Approved set variable to "Approved" else set variable to "Rejected" and put that variable in the email body instead.

Improve this answer
2

Check below workflow actions

  • Extract Substring from End of String
  • Extract Substring from Index of String
  • Extract Substring from Start of String
  • Extract Substring of String from Index with Length Value stored in to a variable, then after that you can use this variable into your workflow actions.
Improve this answer
2
  • Thanks Nagaraju, I forgot to mention I am using SharePoint 2007 (we are upgrading to 2013 this fall). I don't see any "Extract Substring" options.
    – Ryan George
    Jun 27 '13 at 16:05
  • In SharePoint2013 you can find more Utility Action in SharePoint Designer.
    – Nagaraju Pattem
    Jun 28 '13 at 4:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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