userProfileLookup

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.

Important: 

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("john.smith@email.com", "FirstName")

The formula returns the Property Name John.