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

Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

I have a Person field in a SharePoint Online library. I'd like to retrieve the email address of that field's value for use in the Send Email action in Nintex Workflow Cloud. However, this field is returning an integer type (and it's not the employee ID) so I am unable to do a lookup for the email address in either Azure AD or the SharePoint User Profile. How can I retrieve the email address within the workflow from a Person/People Picker field from a SharePoint Online list?

Labels: (1)
0 Kudos
Reply
5 Replies
Highlighted
Nintex Newbie

Re: Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

If you use the 'retrieve an item' action it will return an object variable.

 

When you drill down into the object variable it will break out into 4 components of displayname, ID, email and username, as in the case below for this created by field.

 

Screenshot 2020-11-06 092030.png

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

Yes, I used that action but earlier in the workflow. After I moved the action lower in the workflow closer to when I need to use the email property, the additional properties for the Person field became available. Thank you so much for the insight!

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

Another tidbit: I had the "Allow selection of:" option on the field set to "People and Groups". This is also why only an integer was being returned for the object. I had to change it to " People Only". So, it didn't have anything to do with where the Retrieve an Item action was placed - as I originally thought in my first reply. Thanks again!!

Reply
Highlighted
Nintex Newbie

Re: Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

I think this will only work with the default people fields like created by and edited by.

I cant seem these options for custom fields, like in the task list "assigned to". There i will only get the SharePoint User ID.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Person Field Returns an Integer in Nintex Workflow Cloud

Jump to solution

That "Assigned To" field on the Task list is set to allow "People and Groups" by default. Go into the field settings and set it to "People Only" in order to see the email, username, and display name for this field. 

0 Kudos
Reply