2

I have a choice field (allow multiple selection) in one of the list forms. I have a workflow that sends out an email when an item is added.

My code for the field in my workflow email is just a lookup of the field with a title before it - Choices: [%CurrentItem:Choices%]

I have tried both "As String" and "Choices, with Comma Delimited" options. But none gave the desired result because As String displays it as a string and Choice with Comma displays as item1,item2,item3.

Desired format in the email is item1, item2, item3. or item1 item2 item3

Is this possible?

Please suggest.

1

You can achieve this using "Replace substring in string" action. below are the steps.

  1. Create one local workflow variable
  2. set its value to current item choices.
  3. add "Replace substring in string" action.
  4. Specify "," (comma) in what to replace & specify ", "(space after comma) in replacement string
  5. done. use this variable in your email.

See below screenshot:

enter image description here

  • Hello Vishal, Thanks for your reply. I believe this should work but for some reason it doesn't work for me. I am not sure where i am going wrong. Choice columns has 3 choices (all text), so i created variable:chs data type as String. In the third line, Replace substring in string. I added Variable:chs return field As String/ Semicolumn Delimited. Both options din work. I added Variable chs/output to WF email and both variable doesn't hold any data in email. I have no idea what's going wrong. Can you please suggest? – AXA240778 Jul 31 '17 at 15:21
  • Are u getting different result or getting any error? – SP Developer Jul 31 '17 at 15:26
  • I am not getting any data. I added Hello , [%Variable: Chs%], [%Variable: Output%] in WF email. The email i get just has Hello. No other data. – AXA240778 Jul 31 '17 at 15:27
  • In 1st step, How u r returning the field ? return it as string & try – SP Developer Jul 31 '17 at 15:36
  • That's what i am doing. Returning chs variable as a string. – AXA240778 Jul 31 '17 at 16:17

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.