RobBennettCVS
Rookie

Newbie - Convert Person or Group Value to Display Name in O365

I am trying to create receipts for entries into a Nintex Form. 

 

In the workflow, I am sending an email and the body of the email I want to return the display name for one of my Person or Group fields. right now the email shows i:0#.f|membership|john.smith@email.com

 

I tried using a Workflow variable, but cannot figure out how to get the workflow variable attached to the specific field. I can do a list lookup, but trying to isolate to the current entry. 

 

I tried a userprofilelookup for a variable in the form, but cannot get it to return the value for an item I entered into the form. 

 

I am sure this is easy, but I have been at it for a few hours now.  

0 Kudos
Reply
2 Replies
theMPG
Nintex Professional Services Expert

Re: Newbie - Convert Person or Group Value to Display Name in O365

Greetings,

 

You will need to query the list and pass to a collection using the ID as a input variable. When querying the list item select the column the people picker is mapped too and then you will select 'user name' property. You will then need to execute get item from the collection and pass to a dictionary variable. There you can isolate item from the dictionary via path ie...

 

thePerson/UserName

 

Replace 'thePerson' with your column name.

 

Pass that to a text variable, and that should isolate the value to be sent via mail.

0 Kudos
Reply
Garrett
Contributor

Re: Newbie - Convert Person or Group Value to Display Name in O365

Hi @RobBennettCVS,

 

Easy fix.

1. Click the Contact icon at the end.

Garrett_1-1653894307352.png

2. Select List Lookup.

Garrett_2-1653894407877.png

3. Select the People Column

Garrett_0-1653894248953.png

4. Specify the format. Click the orange icon. You should select Email Address.

Garrett_3-1653894559500.png

5. Remember to click Insert

Garrett_4-1653894662480.png

6. You got the output "i:0#.f|membership|john.smith@email.com" because that's the Default format. You can also specify the User's display name.

 

Hope that helps you. 
Appreciate a Kudos if this helps you. 

0 Kudos
Reply