I have a SPD workflow that sends an email to specific users when a list item has changed. One of the items to display in the email is the category for the item. (Category: [%Current Item:Category%]) with the "Lookup For String" settings set at:

  • Data Source: Current Item
  • Field from Source: Category
  • Return field as: As String (this is grayed out so I am unable to edit)

The email works as expected initially but with each change to the list item, a ";#" is appended to the category in the email -

  • 1st change - Category
  • 2nd change - Category;#
  • 3rd change - Category;#;#
  • 4th change - Category;#;#;#
  • and so on

What can I do to make this stop? I have seen suggestions to change the "Return Field As" dropdown to text but it does not allow me to change this field as it is grayed out.

Thank you and please advise.

  • Whats the data type of "Category" column ?? Jan 31, 2020 at 7:08
  • it is a dropdown - so choice
    – Anngela
    Jan 31, 2020 at 14:38
  • @KarthikJaganathan does the fact that it is a "choice" column help with troubleshooting?
    – Anngela
    Feb 3, 2020 at 15:51
  • is there anyone with a recommendation?
    – Anngela
    Feb 26, 2020 at 21:22
  • @KarthikJaganathan it is a choice from a lookup field
    – Anngela
    Feb 26, 2020 at 21:24


Your Answer

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