Use the userProfileLookup function to return a user profile property of a SharePoint user, such as first name, last name, title, work phone or work email.


Function format

userProfileLookup(Email, Property Name)

  • Email: SharePoint user login name or user email.
  • Property Name: Internal name of the user profile property to lookup.

avg example

userProfileLookup("", "FirstName")

The formula returns the Property Name John.