cancel
Showing results for 
Search instead for 
Did you mean: 

Office 365 Query User Profile Properties

Question

What User Profile properties can be used with the "Office 365 Query User Profile" action?

Answer

The User Profile properties in SharePoint Online and how to reference them in the Office 365 Query User Profile action are as follows:
 
User Profile Property

Reference

Example Output

User Name

UserName

john.allardice@aero-corp.com

Account Name

AccountName

i:0#.f|membership|john.allardice@aero-corp.com

Claim User Identifier

SPS-ClaimID

john.allardice@aero-corp.com

User Principal Name

SPS-UserPrincipalName

john.allardice@aero-corp.com

Name

PreferredName

John Allardice

Work phone

WorkPhone

(123) 456-7890

Work email

WorkEmail

john.allardice@aero-corp.com

SIP Address

SPS-SIPAddress

sip:allardice.j@sip-provider.net

Office

Office

Seattle

Title

Title

Engineer

Title

DisplayName: Job Title

Name: SPS-JobTitle

Engineer (connected to a term set)

Department

Department

Aerospace Engineering

Department

SPS-Department

Aerospace Engineering (connected to a term set)

Public site redirect

PublicSiteRedirect

AERO Corporate Benefits

Language Preferences

SPS-MUILanguages

en-US

SPS-HideFromAddressLists

SPS-HideFromAddressLists

true/false

SPS-RecipientTypeDetails

SPS-RecipientTypeDetails

128

Active Directory Id

ADGuid

c2dfacda-d39b-4ec1-a258-348cbe99025f

Distinguished Name

SPS-DistinguishedName

CN=227adc90-aa29-4025-978d-a8f2a9a7a8b2,OU=8a9b2764-4889-45e9-b19a-0b211b97b51c,OU=Tenants,OU=MSOnline,DC=SPODS1040673957,DC=msoprd,DC=msft,DC=net

msonline-ObjectId

msOnline-ObjectId

227adc90-aa29-4025-978d-a8f2a9a7a8b2 (same as CN= in SPS-DistinguishedName)

SPS-UserType

SPS-UserType

0


Related Links


Labels: (2)
Version history
Revision #:
5 of 5
Last update:
‎09-09-2019 01:13 PM
Updated by: