Pull user info from a people picker

[Alexander Bautz]

This code example show how to pull user info from a people picker (single or multi select), and return the user info – either from the SharePoint userinfo list, or from the SharePoint userprofile service (not available in SP Foundation).

The code is written for user withe DFFS – in the Custom JS textarea.

// Use this code in NewForm or EditForm
$.each(spjs.utility.getFieldValue({"fin":"PeoplePicker1","key":"loginName"}),function(i,login){
var ppData = spjs.utility.userInfo(login);
console.log(ppData);
// User profile is not available in SP Foundation
var userProfile = spjs.utility.userProfile(login);
console.log(userProfile);
});

// Use this in DispForm
$.each(spjs.dffs.beforeProperties["PeoplePicker1_ID"],function(i,userId){
var ppData = spjs.utility.userInfo(userId);
console.log(ppData);
// User profile is not available in SP Foundation
var userProfile = spjs.utility.userProfile(ppData.Name);
console.log(userProfile);
});

Replace “PeoplePicker1” with your FieldInternalName.

Alexander

[Brett Ross]

I’m not a programmer, so I need a little more instruction. I’ve added this to the Custom JS textarea and changed PeoplePicker1 to my field name. But how do I tell it what field to populate? And how do I change it if I want to pull in other properties like the phone number?

• This reply was modified 2 years, 8 months ago by Brett Ross.

[Alexander Bautz]

Hi,
Basically you would add a line below the console.log(userProfile) line like this:

setFieldValue("TheNameOfYourField",userProfile.name_of_property);

To know which properties you have to select from, open the dev tools (hit F12) and select “Console”. Expand the logged profile object and look at the available properties.

Please note that the console.log line should NOT be active in production – it’s just to show the profile and the properties.

Let me know how this works out.

Alexander

[George Hite]

Sorry for the dumb question but I typed in the Custom JS the exact Function for new form as you displayed above and replacing PeoplePicker1 with my Internal Field Name… The console log only displays the DFFS load time tracker. And if I add names it displays Empty string. I don’t know what I’m doing wrong…

Attachments:

1. 

   nothing.jpg
   

2. 

   nothing2.jpg
   

[George Hite]

I forgot to show the code I put into custom JS tab on DFFS… here it is.

Attachments:

1. 

   CAPA_-_New_Item_-_2017-09-06_10.22.40.png
   

[Alexander Bautz]

Hi,
My example for NewForm could have been better as this code will run as the form loads – before you have set anything in the people picker.

If you are trying to pull info from the pp to write to another field, you must wrap the code in a named function and set up a trigger on form save to call this function.

Alexander

[George Hite]

I think I figured it out… in the Misc tab on DFFS section Defer loading of DFFS I had to set the time their… I set it to 300ms don’t know if that’s too much will test by reducing…

[Brett Ross]

I’ve had this working since July, and all of a sudden now, it’s no longer working. I’m pulling in the Contract Manager’s work phone number from the user profiles. Here’s my code.

$.each(spjs.utility.getFieldValue({“fin”:”Contract_x0020_Manager”,”key”:”loginName”}),function(i,login){
var ppData = spjs.utility.userInfo(login);
console.log(ppData);

var userProfile = spjs.utility.userProfile(login);
console.log(userProfile);
setFieldValue(“CM_x0020_Phone_x0020_Number”,userProfile.WorkPhone);
});

I’ve also tried wrapping it in a function, then writing a rule that says, any time the Contract Manager field changes, run the function. But that doesn’t work either.

function PopulatePhone ()
{
$.each(spjs.utility.getFieldValue({“fin”:”Contract_x0020_Manager”,”key”:”loginName”}),function(i,login){
var ppData = spjs.utility.userInfo(login);
console.log(ppData);
// User profile is not available in SP Foundation
var userProfile = spjs.utility.userProfile(login);
console.log(userProfile);
setFieldValue(“CM_x0020_Phone_x0020_Number”,userProfile.name_of_property);
});
}

[Brett Ross]

Nevermind. I see my mistake.

[Alexander Bautz]

I’m glad you figured it out.

Alexander

[Notrega]

Andrew – I work with Brett who responded above and she can’t figure out where I am screwing up. This WAS working a few days ago and I don’t know what kinked it up.

I have a people picker that is only entered on the NewForm and I want to pull out LastName & FirstName into their own fields. I cannot get LastName FirstName fields to display in the DispForm. They display fine on the EditForm.

Do I need code on all three forms or just one?

This is the code I am using on the NewForm and EditForm

function PopulateLastFirst ()
 {
//Pull in Last Name and First Name from Employee field.
$.each(spjs.utility.getFieldValue({"fin":"Employee","key":"loginName"}),function(i,login){
    var ppData = spjs.utility.userInfo(login);
    console.log(ppData);
    // User profile is not available in SP Foundation
    var userProfile = spjs.utility.userProfile(login);
    console.log(userProfile);
    setFieldValue("Last_x0020_Name",userProfile.LastName); 
    setFieldValue("First_x0020_Name",userProfile.FirstName); 
});
}

This is the code I have on the DispForm

function PopulateLastFirst ()
{
$.each(spjs.dffs.beforeProperties["Employee"],function(i,userId){
var ppData = spjs.utility.userInfo(userId);
console.log(ppData);
// User profile is not available in SP Foundation
var userProfile = spjs.utility.userProfile(ppData.Name);
console.log(userProfile);
    setFieldValue("Last_x0020_Name",userProfile.LastName); 
    setFieldValue("First_x0020_Name",userProfile.FirstName); 
});
}

I even tried this on advice from Brett… on the DispForm

function PopulateLastFirst ()
{
$.each(spjs.dffs.beforeProperties["Employee"],function(i,userId){
var ppData = spjs.utility.userInfo(userId);
console.log(ppData);
// User profile is not available in SP Foundation
var userProfile = spjs.utility.userProfile(ppData.Name);
console.log(userProfile);

});
}

Any help you could give would be much appreciated.

• This reply was modified 1 year, 10 months ago by Notrega.
• This reply was modified 1 year, 10 months ago by Notrega.

[Notrega]

I am an idiot… I got it to work

[Alexander Bautz]

I’m glad you figured it out!

Best regards,
Alexander

[Ayanda Makhathini]

Hi Alex

My code is similar(if not the same) as Notrega , but unfortunately he did not post what he did to solve his problem , I cant seem to find the difference between your JS above and his/hers .

I’m trying to populate the users title and SipAddress in the respective fields but when I save on edit and New form i doesnt seem to get the information of the user. I have the rule to trigger the function on save but it still get nothing.

Can you help me?

(I did remove _ID from DispForm but it still didnt work)

Attachments:

1. 

   Screenshot_66.png
   

2. 

   Screenshot_67.png
   

[Alexander Bautz]

Hi,
Do you see the output in the console (you must hit F12 and select Console) when running the code?

Please note that the console.log lines must not be in the production code – these are for debugging only.

Alexander

[Ayanda Makhathini]

Hi Alex

my code is showing undefined. Even when i test the spjs.utility.userInfo(login); section which i think is to get the user details in the people picker its returning undefined

I also have triggered the function on save in the rules.

fieldInternalName = SP_x0020_Email_x0020_Valid

Thanks

Attachments:

1. 

   Screenshot_70.png
   

2. 

   Screenshot_71.png
   

[Ayanda Makhathini]

Hi Alex

I found the issue it was my JS syntax. my query is trying to set (userprofile) that hasnt been set hence undefined.

function populateSPNameAndEmail()
{
$.each(spjs.utility.getFieldValue({“fin”:”SP_x0020_Email_x0020_Valid”,”key”:”loginName”}),function(i,login){
var ppData = spjs.utility.userInfo(login);
console.log(ppData);
setFieldValue(“Full_x0020_Name”,ppData.Title);
setFieldValue(“Email_x0020_Address”,ppData.SipAddress);
});
}

I had the wrong field aswell in the above code for SipAdress.
Thank you for the jQuery its very useful

[Alexander Bautz]

I’m glad you figured it out.

Alexander

[David Jeremias]

Hey Alexander,

Can this be done in the display form with a multi-person field (for example: to display the loginName of each person in a single multi-person field)?

Thanks!
David

[Alexander Bautz]

Hi,
You can use a snippet like this to get the users from a multichoice (or single choice people picker) and get their login name:

var userLoginNames = [];
jQuery.each(spjs.dffs.beforeProperties.PeoplePicker1_ID,function(i,id){
	userLoginNames.push(spjs.utility.userInfo(id).Name);
});
console.log(userLoginNames);

Change “PeoplePicker1” with your people picker internal name.

Alexander

• This reply was modified 1 year ago by Alexander Bautz.

[Author]

Posts