Get firstname only from People or groups column

Question

Get firstname only from People or groups column

peac3 (TechnicalUser)

(OP)

26 Feb 13 22:35

Hi All,

I am trying to send the email from the sharepoint by using the firstname only from group or persons column.

Let's say the fullname is John Smith.

Atm, in the email header it's showing like this:

CODE

Dear Smith, John,

Task has been assigned for you

I would like showing as below:

CODE

Dear John,

Task has been assigned for you

The column name called "Assign To"

The code looks like this:

CODE

Dear [%Current Item:Assign To%],

It looks simple but I can't crack it for few days.
Any help would be appreciated, Thank you...

peac3 (TechnicalUser) · Answer 1 · 2013-02-26 22:36:33

ps: the email coming from a workflow in the list.

ehaze (TechnicalUser) · Answer 2 · 2013-02-28 17:00:56

When you are setting the [%Current Item:Assign To%], change the 'Lookup for String' data source to User Profiles. Then select First Name from the 'Field from source' box.

Doing this, more or less will query the User Profile data source, and you will want to query by your Assign To field.

If needed, I can post a more detailed how-to.

http://www.sharepointed.com/

Come Join Us!

Posting Guidelines

Get firstname only from People or groups column