Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

Question

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 protected];#23 -> everything works fine though, the recipient gets the email

If the workflow will add 2 lookup values the field looks like this:

[email protected];#23;[email protected];#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.

Answer 1

You should use

Return as email id semicolon delimited

That way there would be no lookup id.

Answer 2

I had same problem, solution is just create a new SPFieldLookupValue and read LookupValue property. It's quite simple, but can save some time for others.

public String LinkTitleCode
{
    get
    {
        var lookupText = Get<String>("LinkTitleCode");
        return new SPFieldLookupValue(lookupText).LookupValue;
    }
}

Answer 3

I had the same problem, got "ID# Lookup text" returned from workflow.

The workflow was set to return field as "String". I changed it to "Lookup Value (as text)" and it worked.