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|domainusername
The userProfileLookup in-line function help text listed the syntax of the function as:
userProfileLookup("domainlogin", "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("domainusername","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