I am using Nintex workflow to notify the parties via email the parties involved in Person fields.
I would like to set the email text to display the names first name last name - like Robert Perkins, not Perkins.Robert
seems like this should be simple, but I am having trouble with it.Learn More
Solved! Go to Solution.
Could you clarify a few things about your question...
Thanks for your interest. Sorry for the confusion.
1. I am OK with the To and From Fields. I am trying to populate data in the email body.
email body wording as follows: <<Business owner>> is a custom list item. (Person)
want the item to display Robert Perkins, not Perkins.Robert.
"Thank you for your recent technology request.
Your request has been sent to <<BUSINESS OWNER>> for
validation. <<BUSINESS OWNER>> must validate the request for
it to be sent for analysis and review."
2. internal user, but I have that working ok.
3. Sending from send notification action.
Ok, so I assume you have a variable or a column of type "Person or Group", right? In that case, all you need to do is create a new variable of type Single line of Text, call it something like BusinessOwnerDisplayName. Then use the Set Variable action to set the BusinessOwnerDisplayName to either a variable or a column. However, if you click the ellipsis (...) after the value you are assigning to, you will be able to select the return type of the value. If you are converting from a People or Group variable or column, then you can select the return type as "Display Name", as shown below.
You can then use the BusinessOwnerDisplayName for the <<Business Owner>>.
Feeling stupid here.. but this is what I am doing.
Business Owner is a column with type Person or Group.
2. Set Variable action set the BusinessOwnerDisplayName to either a variable or a column.
Here is what I am doing.
3. Here is what I am getting. still <last name>.<First name>???
Well, could it be, that in your active directory the display name is [lastname].[firstname]? This setting is referring to an OOTB SharePoint feature, which is just providing whatever is stor in your ad.
You'll need to check with your network admin on how the display name is configured in AD. You could however use the Build Sting action with some functions to parse / format the display name as you wish.
Your screenshot appears to have the rest of it configured properly as I suggested in my prior reply.
That might be my solution, since the admins at the farm will not change active directory. I know how to build a string, but not aware of a out of the box function for parsing/ formatting... would need to be able to identify the position of the "." ?
I developed a UDA that does a LDAP query to return specifics of an AD account. So for example, it returns the Firstname, lastname, phone details etc and also a combined fullname, among other things. You should be able to pull in any AD properties you require. I too was getting the issue with Display Name showing "Lastname, FirstName" and found it undesirable in messaging.
I had a similar issue and needed to flip the first and last name. (Last, First -> First Last)
I created a workflow using a regular expression and collection operation to flip the columns.
|createdbyDisplayName||Single line of text|
|first||Single line of text|
|last||Single line of text|
|fullName||Single line of text|
|Workflow Actions||Workflow Structure|
(mine returned as Last, First and I'm splitting the string on the comma)
Collection operation (1)
Collection operation (2)