Sp-dev-docs: Person column properties - column formatting

[hbliznakov21]

Category

• [X] Question
• [ ] Typo
• [ ] Bug
• [ ] Additional article idea

Person column properties - column formatting

Hi,

I am trying to find all properties that are supported for the person column in SharePoint online.
Here is the example I found in the docs.microsoft.com

{
"id": "122",
"title": "Kalya Tucker",
"email": "[email protected]",
"sip": "[email protected]",
"picture": "https://contoso.sharepoint.com/kaylat_contoso_com_MThumb.jpg?t=63576928822"
}

I found also the the "department" is available and I was wondering what else we can get from the user profile.

Thank you!

[msft-github-bot]

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

[thechriskent]

Those are the only values available for use in column formatting. There are other values, however, available from person fields when retrieving them through other means, such as the REST API. Is that what you are referring to?

Some of those additional properties include:

• MobileNumber
• AboutMe
• IsSiteAdmin
• Deleted
• Hidden
• Department
• JobTitle
• LastName
• FirstName

Again, the above are not available for column formatting.

[hbliznakov21]

Hi Chris, Thank you for your quick answer. Yes, I know that it is possible to retrieve more user data using REST API. I am sending screen shouts of the department propriety I can use in the column formatting, which was surprise for me and my profile in Azure.

That's way I send a question to the community to see if there is additional options I am not aware off.
Thank you!

[thechriskent]

Wow, you're blowing my mind! I'm not able to recreate this yet but I'm looking into it further and will see what I can find out.

[bcameron1231]

Here is the list of properties available

• id
• title
• email
• sip
• picture
• jobTitle
• department

[hbliznakov21]

@bcameron1231 Perfect! Thanks!

[thechriskent]

Thanks @bcameron1231 and @hbliznakov21!

Looks like we need to update the documentation! Guess that will teach me to not put the word not in bold in my responses 😄!

[msft-github-bot]

Issues that have been closed & had no follow-up activity for at least 7 days are automatically locked. Please refer to our wiki for more details, including how to remediate this action if you feel this was done prematurely or in error: Issue List: Our approach to locked issues