cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
jlukins
Nintex Newbie

userProfileLookup - #Value! error

Jump to solution

I am a new user to Nintex so sorry if this is a simple problem.

 

I am trying to use the userProfileLookup tool to output the current user details (department, title etc) in a Nintex 2013 form.

 

I am using the Calculated Value form with the formula: userProfileLookup({Common:CurrentUser},"Department") . When I actually view the form all I get is #Value! in the field.

 

I know that that formula should work because I have used it as a Form Variable and loaded it from a Workflow.

 

Thanks for the help

Labels: (2)
Tags (2)
Reply
10 Replies
fhunth
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

Take a look at this >>> Nintex Forms 2013 - Release Notes

It seems to be solved on the 2.3.2.0 version

0 Kudos
Reply
jlukins
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

Hi Fernando. Thanks for the quick reply.

I've had a look and I'm on version 2.5.0.0.

edit:

Here are my full specs:

Windows Server 2012 R2 Standard

Sharepoint Server 2013 (15.0.4569.1506)

Nintex Forms 2013 2.5.0.0

Nintex Workflow 2013 3.1.2.0

0 Kudos
Reply
bamaeric
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

Hi Josh,

You mentioned getting user details with the userProfileLookup runtime function.  Are you able to use the formula to successfully get other values (such as PreferredName)?

0 Kudos
Reply
Automation Master
Automation Master

Re: userProfileLookup - #Value! error

Jump to solution

Which version of SharePoint do you have (Foundation, Standard, Enterprise) ?

With SharePoint Foundation there's no user profile service and the userProfileLookup function can't work.

0 Kudos
Reply
jlukins
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

I am using SharePoint Server with Standard Client Access License.

0 Kudos
Reply
jlukins
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

I have been working through this issue with Nintex support. We have not solved it yet but we are under the assumption that the issue is a result of a separate error message that occurs when trying to change the "Connected to" dropdown (see image).nintex-error.png

0 Kudos
Reply
Automation Master
Automation Master

Re: userProfileLookup - #Value! error

Jump to solution

Hello,

Have you tried drag 'n dropping a new calculated field onto the form (one that is not connected to anything) to see if you get different behavior?  Also have you tried hard-coding a value instead of Current User variable just to see if you are getting results?   Lastly, confirm that Department has a valid value for the user you are trying to query upon.

Thanks,

Mike

0 Kudos
Reply
jlukins
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

So I think I have finally solved this issue. It was a strange fix but in the scheme of things should have been something that was set up when we set up Sharepoint.

 

Basically there was no site collection at the root level (http://sharepoint.domain). The only site collection was at http://sharepoint.domain/sites/sitename. Once I created the root site all the problems (both Javascript and userProfileLookup) went away.

 

Thanks for the help guys.

Reply
allan
Nintex Newbie

Re: userProfileLookup - #Value! error

Jump to solution

Thanks Josh for getting back several month later to post the solution. 
That was that in my case, love you !

0 Kudos
Reply