I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As Lookup Values, Comma Delimited" I'm still getting the lookup id just after the lookup value like this:
email@example.com;#23 -> everything works fine though, the recipient gets the email
If the workflow will add 2 lookup values the field looks like this:
firstname.lastname@example.org;#23;email@example.com;#24 -> end result in nothing, the workflow gets canceled.
Is there a way to get rid of the lookup id?
EDIT: The value I'm retrieving with the lookup are "email addresses, semicolon delimited"
I've tried to create a local variable to store the lookup values (in order to return it as "email addresses, semicolon delimited", but when I set the variable value to the lookup value I can only return it as "String", "Lookup Value, comma delimited" and "Lookup Ids, comma delimited" which makes the local variable unable to return it as the intended type.
I'm getting a "coercion failed" error.