Skip to main content
Nintex Community Menu Bar

Lookup formula to return Email Address from 'Person or Group' field

  • July 1, 2019
  • 1 reply
  • 11 views
Forum|alt.badge.img+1

Good morning all

I am using this formula to display the user name from a Person or Group filed (Assigned to) in a separate list (Digital Services Task List):

 

 

parseLookup(lookup("Digital Services task list", "ID", Task ID field, "Assigned to"))

 

It returns the user name:

2887i942B213DA601A33A.png

I would also like to display the users email address:

2888iEBB0586B7616A4E8.png

Is there a way to modify my formula to return the EMail value instead of the display name?

    1 reply

    Forum|alt.badge.img+14
    • emha
    • Scholar
    • July 1, 2019

    have a look on userProfileLookup() runtime function

    https://help.nintex.com/en-US/nintex2013/help/#Forms/RootCategory/Designer/Nintex.Forms.RuntimeFunctions.htm%3FTocPath%3DForms%7CUsing%2520the%2520Form%2520Designer%7C_____20

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement