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

Nintex forms userProfileLookup not picking the Department and WorkPhone(calculated field)

Hi All,

        I have a Request form in which the RequestedBy user loaded at first and i want to show the department and workphone of the current user in form loading. I have given formula field with the below formulas

userProfileLookup(RequestedBy, 'Department') => for Department

userProfileLookup(RequestedBy, 'WorkPhone') =>for phone.

Same formula i have used in my developement server for getting these data. It works perfectly. But in my production server it shows "#value!"

Please find the attachments for calculated field config.  both single quotes and double quotes i already tried. eg: 'Department and "Department"'

Please help me.

Thanks

Labels: (1)
Tags (1)
0 Kudos
Reply
3 Replies
lakshminarayana
Nintex Newbie

Re: Nintex forms userProfileLookup not picking the Department and WorkPhone(calculated field)

Are you getting the correct department value with your SharePoint field settings in list?.

Reply
nidhincee
Nintex Newbie

Re: Nintex forms userProfileLookup not picking the Department and WorkPhone(calculated field)

This settings i already done. instead of Tester its Requested By. When we change the Requested by and during current user the department and phone should be shown in calculated field . That is my requirement. 

0 Kudos
Reply
lakshminarayana
Nintex Newbie

Re: Nintex forms userProfileLookup not picking the Department and WorkPhone(calculated field)

Yes i understood your thing. But instead of using Nintex Form, in a SharePoint list using field settings is it generating phone number and department values correctly (your production environment)?

If it is not generating, may be some problem with your active directory. 

Reply