Skip to main content
Nintex Community Menu Bar

Problem with userProfileLookup returns #value

  • December 19, 2017
  • 10 replies
  • 41 views

Forum|alt.badge.img+2

Hello everyone, 

I had a problem with the sharepoint form, I want to get the username by userProfileLookup and I used this function 

userProfileLookup(Current User,"PreferredName")

and it returned #Value 

what is the problem?

10 replies

Forum|alt.badge.img+9
  • Nintex Partner
  • December 19, 2017

PreferredName doesn't sound like a valid property, or at least one that isn't used. Try "DisplayName"


Forum|alt.badge.img+2
  • Author
  • December 19, 2017

I actually tried everything, all functions like "DisplayName", "First Name", "LastName" and "UserName"...etc. But all of them didn't made any difference, still they return #Value 


Forum|alt.badge.img+9
  • Nintex Partner
  • December 19, 2017

try using single quotes userProfileLookup(Current User,'PreferredName') also try publishing it and checking the actual form but not in preview mode. Shouldn't be a reason why it's not working. You can also try instead of Current User variable, use and actual domain/user to see if it has something to do with that.


Forum|alt.badge.img+16

I am assuming you selected Current User and didn't just type it in?


Forum|alt.badge.img+2
  • Author
  • December 20, 2017

I tried it too now and still no use ): 

someone told me the problem may be from the directory 

because everyone have the same problem in my team

I think this is the only solution remain


Forum|alt.badge.img+2
  • Author
  • December 20, 2017

yeah I tried to type it in and it gave me an error, it didn't work at all. Maybe because the version of SharePoint I'm using is 2017 it's not accepting the typing way 


Forum|alt.badge.img+9
  • Nintex Partner
  • December 20, 2017

Badeea,

In order for it to work you have to select the "CurrentUser" variable from the right. You can't just type it in. If you've don it correctly it will show in red. You tried it that way, right?


Forum|alt.badge.img+2
  • Author
  • December 20, 2017

Yes I tried all ways to do it, but also with no use, the problem still didn't get solved


Forum|alt.badge.img+9
  • Nintex Partner
  • December 20, 2017

Is your sharepoint environment synced to active directory with sharepoint's user profile service?


Forum|alt.badge.img+2
  • Rookie
  • August 16, 2024

Is this issue has been resolved? I have exactly the same issue, but no luck. I am still waiting for Nintex support to respond. 


Thanks