userprofilelookup Runtime Function
AdminDan Stoll
(Director, Technical Marketing, Nintex)
shared this idea
I am pleased to announce the UserProfileLookup runtime function has been added to the Rules Builder and Calculated Value control.
Please be aware that this function requires granting the Nintex app additional permissions to read user profiles. Your tenant administrator will be required to configure the app permissions. See the online help available at https://help.nintex.com/en-US/o365/#o365/O365Forms/Admin/UserProfileAdmin.htm?Highlight=user profile
-
JodieS
commented
I have allowed the form access to user profiles (as per link provided), and have added a calculated field with the following formula:
userProfileLookup(Current User (Email), "Manager")
I cant get it to work - it shows #Value! every time. What am I missing?
-
Anonymous
commented
Thanks Euan, I will do that.
-
shaunlub
commented
If this requires access over and above the access given to the 365 workflows (there is a setting in the workflow window), then I haven't given them access. If this needs to be set above the Site/Site Collection level, then I will have to request someone to set that...?
-
shaunlub
commented
Euan, I was experiencing very much the same result. As stated in my last comment. It's not quite clear how the values/fields in the brackets are to be edited. Trying various combinations give results like Prasanna (i.e. #Value!) or nothing.
-
Prasanna Sathyamurthy
commented
@Euan Gamble- I am still not able to get this to work in our tenant. I see this error message in the calculated value control: "#Value!"
I would like to know what I am missing. -
shaunlub
commented
I'm still not managing to get this work (on a site where the workflow can correctly query the user details).
The layout shown in the form designer is not very clear as to what is expected:
userProfileLookup("email","InternalPropertyName")Should this be used as-is?
Or should this work?
userProfileLookup("Current User (Email)", "Department") -
shaunlub
commented
The help link does not seem to show anything related to this yet.(Maybe ready, but not pubilshed?)
-
shaunlub
commented
Good to hear this is starting.
-
Rebekka John
commented
Please release this function it's really necessary!
-
Armelle Vérité
commented
Please make it happen really soon or give some time frame when this will happen. I'm really stuck in a project and I have no idea how to display the Phone number and the Email (e-Mail display in NF is not right) . Also I am not authorised to upload JS or grant the app more rights.
-
shaunlub
commented
Good news. Can't wait.... Planned means what kind of time frame?
-
Murat Kretschmer
commented
Same with us. We are desperatly seeking such a function. Please make it happen soon.
-
shaunlub
commented
I would realy like this sooner than later. It would be great if the People Picker control could harness the lookup behind the Person or Group column in SharePoint Lists - which would give us access to the following useful information from the user profile:
Work email
Mobile phone
Department
Title
First name
Last name
Work phone
Office
Picture (3 different sizes)
Name (with picture and details) -
MSB
commented
Will this feature be available in O365? Thank you.
-
AndrewP
commented
The Emerson team would be interested to know if there is an ETA on this function.
-
Anonymous
commented
Any update on when this feature will be available for o365?
-
shaunlub
commented
It would be great to have an update on this.
-
Aditi Das
commented
Without this feature how u released the Ninetx ? May be you are not aware that this the basic functionality needed for development.
-
B SRINIVAS RAO
commented
Very important feature to have.
-
Warwick W
commented
Cool! some voices here have been planned for years though :) Speedy development to you and your team!