AnsweredAssumed Answered

Returning displayName using userProfileLookup

Question asked by sjnbham on Mar 2, 2016
Latest reply on May 29, 2018 by debosmita03

I'm trying to use the following function for a calculated field on a form but no value is being returned:

 

     userProfileLookup(Current User,"displayName")

 

We're using Claims-based authentication for our SharePoint 2013 on-prem farm. So our user names are in the format of:

 

     i:0#.w|domain\username

 

The userProfileLookup in-line function help text listed the syntax of the function as:

 

    userProfileLookup("domain\login", "InternalPropertyName")

 

So I tried substituting a manual value for the current user value to see if maybe it was because our usernames were in Claims format:

 

     userProfileLookup("domain\username","displayName")

 

Still no dice.

 

What I'm attempting to do is use the display name of the current user in a form rules formula to hide a field on a form unless the current user is listed in at least one of several people picker fields on the form. But I'm struggling to get the Current User value into a format that will match the values in the people picker fields.

 

Using Nintex Forms 2013 Standard ver 2.5.0.0 and SharePoint 2013 Enterprise Aug 2015 CU

Outcomes