Office 365 Users
Office 365 Users Connection provider lets you access user profiles in your organization using your Office 365 account. You can perform various actions such as get your profile, a user's profile, a user's manager or direct reports and also update a user profile.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions |
Power Automate | Standard | All Power Automate regions |
Power Apps | Standard | All Power Apps regions |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://www.office.com/ |
To use this connector in Power Apps, learn more here.
The followings are some of the known limitations of using Office 365 Users connector.
- To use this integration, you will need access to an Office 365 mailbox that has the REST API enabled. To make a connection, select Sign In. You will be prompted to provide your Office 365 account, follow the remainder of the screens to create a connection.
- The connector does not support Government Community Cloud High (GCCH) accounts in LogicApps US Government Cloud.
- If you see an error using the connector, please check that the REST API is enabled. Accounts on a dedicated (on-premise) mail server or accounts that are sandbox (test) accounts may also see an error. Your administrator can learn how to migrate a mailbox here. Additionally, if you are using an EWS application access policy, please ensure that the following user-agents are allowed: "LogicAppsDesigner/*","azure-logic-apps/*","PowerApps/*", "Mozilla/*"
- Get manager (V2) action returns "No manager found for the specified user".
- This happens when the user does not have a manager configured in Microsoft Entra ID. Learn how to update an Microsoft Entra ID user's profile to configure a manager here.
- Get direct reports (V2), Get manager (V2), Get my profile (V2) and Get user profile (V2) actions declare an input parameter
Select fields
. You can specify a coma separated list of fields to select in this parameter (learn more about available fields here). For example:department, jobTitle
displayName, surname, mailNickname, userPrincipalName
- If the parameter is not specified, the following fields are selected by default: aboutMe, accountEnabled, birthday, businessPhones, city, companyName, country, department, displayName, givenName, hireDate, id, interests, jobTitle, mail, mailNickname, mobilePhone, mySite, officeLocation, pastProjects, postalCode, preferredLanguage, preferredName, responsibilities, schools, skills, state, streetAddress, surname, userPrincipalName, userType.
- Get direct reports (V2), Get manager (V2), Get my profile (V2) and Get user profile (V2) actions may fail with
403 Forbidden
error if some of the fields that are selected by default as stated above are blocked by your tenant policies. Please contact your tenant admin to allowlist the fields or try specifyingSelect fields
parameter explicitly.- Make sure that Everyone except external users has permissions to
My Site Host
for both “My setting” and “Permission” sections in SharePoint Admin center in order to query the fields that are selected by default as stated above.
- Make sure that Everyone except external users has permissions to
- Conditional Access policies can prevent the connector from running as expected. Example of an error: "AADSTS53003: Access has been blocked by Conditional Access policies. The access policy does not allow token issuance.". Please refer to Microsoft Entra ID Conditional Access documentation for more details.
- Get my profile (V2) action may fail with
401 Unauthorized
error when used by guest users. To workaround this, try specifyingSelect fields
parameter explicitly to:id, displayName, givenName, surname, mail, mailNickname, accountEnabled, userPrincipalName, department, jobTitle, mobilePhone, businessPhones, city, companyName, country, officeLocation, postalCode
. - SearchUser (v2) may fail with
403 Insufficient privileges to complete the operation
error.- Guest users are limited by design. An alternative suggestion is to create a user list populated by the Office365 user list on SharePoint, and then use this list as your data source.
- Additionally, restricting the access rights of guests can enhance the information security of your organization. It is recommended to evaluate the security implications of this operation.
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 1000 | 60 seconds |
Get direct reports (V1) [DEPRECATED] |
This action has been deprecated. Please use Get direct reports (V2) instead.
|
Get direct reports (V2) |
Retrieves the user profiles of the specified user's direct reports. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties |
Get manager (V1) [DEPRECATED] |
This action has been deprecated. Please use Get manager (V2) instead.
|
Get manager (V2) |
Retrieves the profile of the specified user's manager. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties |
Get my profile (V1) [DEPRECATED] |
This action has been deprecated. Please use Get my profile (V2) instead.
|
Get my profile (V2) |
Retrieves the profile of the current user. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties |
Get my trending documents |
Retrieves the trending documents for the signed in user |
Get relevant people |
Get relevant people. |
Get trending documents |
Retrieves the trending documents for a user |
Get user photo (V1) [DEPRECATED] |
This action has been deprecated. Please use Get user photo (V2) instead.
|
Get user photo (V2) |
Retrieves the photo of the specified user if they have one |
Get user photo metadata |
Get user photo metadata. |
Get user profile (V1) [DEPRECATED] |
This action has been deprecated. Please use Get user profile (V2) instead.
|
Get user profile (V2) |
Retrieves the profile of a specific user. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties |
Search for users (V2) |
Retrieves the user profiles that match the search term (V2). |
Search for users [DEPRECATED] |
This action has been deprecated. Please use Search for users (V2) instead.
|
Send an HTTP request |
Construct a Microsoft Graph REST API request to invoke. These segments are supported: 1st segement: /me, /users/ 2nd segment: messages, mailFolders, events, calendar, calendars, outlook, inferenceClassification. Learn more: https://docs.microsoft.com/en-us/graph/use-the-api. |
Update my profile |
Updates the profile of the current user |
Update my profile photo |
Updates the profile photo of the current user. The size of the photo must be less than 4 MB. |
This action has been deprecated. Please use Get direct reports (V2) instead.
Retrieves the user profiles of the specified user's direct reports.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
- response
- array of User
Retrieves the user profiles of the specified user's direct reports. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
id | True | string |
User principal name or id. |
Select fields
|
$select | string |
Comma separated list of fields to select. Example: surname, department, jobTitle |
|
Top
|
$top | integer |
Limit on the number of results to return. By default returns all entries. |
Returns
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of GraphUser_V1 |
Value |
This action has been deprecated. Please use Get manager (V2) instead.
Retrieves the profile of the specified user's manager.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
Represents a User object in the directory
- Body
- User
Retrieves the profile of the specified user's manager. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
id | True | string |
User principal name or id. |
Select fields
|
$select | string |
Comma separated list of fields to select. Example: surname, department, jobTitle |
Returns
User from Graph API
- Body
- GraphUser_V1
This action has been deprecated. Please use Get my profile (V2) instead.
Retrieves the profile of the current user.
Returns
Represents a User object in the directory
- Body
- User
Retrieves the profile of the current user. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Select fields
|
$select | string |
Comma separated list of fields to select. Example: surname, department, jobTitle |
Returns
User from Graph API
- Body
- GraphUser_V1
Retrieves the trending documents for the signed in user
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Filter query
|
$filter | string |
An OData filter to filter the resources selected. Filter selected resources on ResourceVisualization/Type or ResourceVisualization/containerType |
Returns
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of GraphTrending |
value |
Get relevant people.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
Represents a list from the Graph API
Retrieves the trending documents for a user
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
id | True | string |
User principal name or id. |
Filter query
|
$filter | string |
An OData filter to filter the resources selected. Filter selected resources on ResourceVisualization/Type or ResourceVisualization/containerType |
Returns
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of GraphTrending |
value |
This action has been deprecated. Please use Get user photo (V2) instead.
Retrieves the photo of the specified user if they have one.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
- Image file content
- binary
Retrieves the photo of the specified user if they have one
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
id | True | string |
User principal name or id. |
Returns
- Image file content
- binary
Get user photo metadata.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
Photo Metadata class
- Body
- ClientPhotoMetadata
This action has been deprecated. Please use Get user profile (V2) instead.
Retrieves the profile of a specific user.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
userId | True | string |
User principal name or id. |
Returns
Represents a User object in the directory
- Body
- User
Retrieves the profile of a specific user. Learn more about available fields to select: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
User (UPN)
|
id | True | string |
User principal name or id. |
Select fields
|
$select | string |
Comma separated list of fields to select. Example: surname, department, jobTitle |
Returns
User from Graph API
- Body
- GraphUser_V1
Retrieves the user profiles that match the search term (V2).
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Search term
|
searchTerm | string |
Search string (applies to: display name, given name, surname, mail, mail nickname and user principal name). |
|
Top
|
top | integer |
Limit on the number of results to return. Minimum value is 1. Default value is 1000. |
|
Is search term required
|
isSearchTermRequired | boolean |
If set to 'Yes' then no user profiles will be returned when the search term is empty. If set to 'No' then no filtering will be applied when the search term is empty. |
Returns
Class representing entity list response from an Office API.
This action has been deprecated. Please use Search for users (V2) instead.
Retrieves the user profiles that match the search term.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Search term
|
searchTerm | string |
Search string (applies to: display name, given name, surname, mail, mail nickname and user principal name). |
|
Top
|
top | integer |
Limit on the number of results to return. By default returns all entries. |
Returns
- response
- array of User
Construct a Microsoft Graph REST API request to invoke. These segments are supported: 1st segement: /me, /users/ 2nd segment: messages, mailFolders, events, calendar, calendars, outlook, inferenceClassification. Learn more: https://docs.microsoft.com/en-us/graph/use-the-api.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
URI
|
Uri | True | string |
The full or relative URI. Example: https://graph.microsoft.com/{version}/{resource}. |
Method
|
Method | True | string |
The HTTP method (default is GET). |
Body
|
Body | binary |
The request body content. |
|
Content-Type
|
ContentType | string |
The content-type header for the body (default is application/json). |
|
CustomHeader1
|
CustomHeader1 | string |
Custom header 1. Specify in format: header-name: header-value |
|
CustomHeader2
|
CustomHeader2 | string |
Custom header 2. Specify in format: header-name: header-value |
|
CustomHeader3
|
CustomHeader3 | string |
Custom header 3. Specify in format: header-name: header-value |
|
CustomHeader4
|
CustomHeader4 | string |
Custom header 4. Specify in format: header-name: header-value |
|
CustomHeader5
|
CustomHeader5 | string |
Custom header 5. Specify in format: header-name: header-value |
Returns
- response
- ObjectWithoutType
Updates the profile of the current user
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
About Me
|
aboutMe | string |
About Me |
|
Birthday
|
birthday | date-time |
Birthday |
|
Interests
|
interests | array of string |
Interests |
|
My Site
|
mySite | string |
My Site |
|
Past Projects
|
pastProjects | array of string |
Past Projects |
|
Schools
|
schools | array of string |
Schools |
|
Skills
|
skills | array of string |
Skills |
Updates the profile photo of the current user. The size of the photo must be less than 4 MB.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Image content
|
body | True | binary |
Image content |
Content-Type
|
Content-Type | True | string |
Image content type (like 'image/jpeg') |
Trending documents from Graph API
Name | Path | Type | Description |
---|---|---|---|
Id
|
id | string |
Unique identifier of the relationship |
Weight
|
weight | float |
Value indicating how much the document is currently trending |
Resource visualization
|
resourceVisualization | resourceVisualization |
resourceVisualization |
Resource reference
|
resourceReference | resourceReference |
resourceReference |
resourceVisualization
Name | Path | Type | Description |
---|---|---|---|
Title
|
title | string |
The item's title text |
Type
|
type | string |
The item's media type (can be used for filtering for a specific file based on a specific type) |
Media type
|
mediaType | string |
The items media type (can be used for filtering for a specific type of file based on supported IANA Media MIME types) |
Preview image URL
|
previewImageUrl | string |
A URL leading to the preview image for the item |
Preview text
|
previewText | string |
A preview text for the item |
Container web URL
|
containerWebUrl | string |
A path leading to the folder in which the item is stored |
Container display name
|
containerDisplayName | string |
A string describing where the item is stored |
Container type
|
containerType | string |
Can be used for filtering by the type of container in which the file is stored |
resourceReference
Name | Path | Type | Description |
---|---|---|---|
Web URL
|
webUrl | string |
A URL leading to the referenced item |
Id
|
id | string |
The item's unique identifier |
Type
|
type | string |
A string value that can be used to classify the item, such as "microsoft.graph.driveItem" |
Represents a list from the Graph API
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Person |
Value |
Represents a Person
Name | Path | Type | Description |
---|---|---|---|
Person id
|
id | string |
A unique identifier for the Person object in the directory |
Display name
|
displayName | string |
The person's display name |
Given name
|
givenName | string |
The person's given name |
Surname
|
surname | string |
The person's surname |
Birthday
|
birthday | string |
The person's birthday |
Person Notes
|
personNotes | string |
Free-form notes that the current user has taken about this person |
Is Favorite?
|
isFavorite | boolean |
If the current user has flagged this person as a favorite |
Job title
|
jobTitle | string |
The person's job title |
Company name
|
companyName | string |
The name of the person's company |
Department
|
department | string |
The person's department |
Office location
|
officeLocation | string |
The location of the person's office |
Profession
|
profession | string |
The person's profession |
User Principal Name (UPN)
|
userPrincipalName | string |
The user principal name(UPN) of the user.The UPN is an Internet-style login name for the user based on the Internet standard RFC 822. By convention, this should map to the user's email name.The general format is alias @domain, where domain must be present in the tenant's collection of verified domains. |
IM Address
|
imAddress | string |
The person's VOIP SIP address |
Scored Email Addresses
|
scoredEmailAddresses | array of ScoredEmailAddress |
Collection of the person's email addresses with a relevance score |
Phones
|
phones | array of Phone |
The person's phone numbers |
Represents a scored email address
Name | Path | Type | Description |
---|---|---|---|
Email Address
|
address | string |
The email address |
Relevance Score
|
relevanceScore | double |
The relevance score of the email address. A relevance score is used as a sort key, in relation to the other returned results. A higher relevance score value corresponds to a more relevant result. Relevance is determined by the user's communication and collaboration patterns and business relationships. |
Represents a phone number
Name | Path | Type | Description |
---|---|---|---|
Phone Number
|
number | string |
The phone number |
Phone Type
|
type | string |
The type of phone number. Possible values: home, business, mobile, other, assistant, homeFax, businessFax, otherFax, pager, radio. |
Represents a User object in the directory
Name | Path | Type | Description |
---|---|---|---|
User id
|
Id | string |
A unique identifier for the user object in the directory. |
Account enabled?
|
AccountEnabled | boolean |
true if the account is enabled; otherwise, false. This property is required when a user is created. |
Business phones
|
BusinessPhones | array of string |
A list of business phone numbers for the user |
City
|
City | string |
The city in which the user is located. |
Company name
|
CompanyName | string |
The name of the company in which the user works. |
Country
|
Country | string |
The country/region in which the user is located; for example, "US" or "UK". |
Department
|
Department | string |
The name of the department in which the user works. |
Display name
|
DisplayName | string |
The name displayed in the address book for the user. This is usually the combination of the user's first name, middle initial and last name. This property is required when a user is created and it cannot be cleared during updates. |
Given name
|
GivenName | string |
The given name (first name) of the user. |
Job title
|
JobTitle | string |
The user’s job title. |
Email
|
string |
The SMTP/email address for the user, for example, "jeff@contoso.onmicrosoft.com". Read-Only. |
|
Nickname
|
MailNickname | string |
The mail alias for the user. This property must be specified when a user is created. |
Office location
|
OfficeLocation | string |
The office location in the user's place of business. |
Postal code
|
PostalCode | string |
The postal code for the user's postal address. The postal code is specific to the user's country/region. In the United States of America, this attribute contains the ZIP code. |
Surname
|
Surname | string |
The user's surname (family name or last name). |
Telephone number
|
TelephoneNumber | string |
The primary cellular telephone number for the user. |
User Principal Name (UPN)
|
UserPrincipalName | string |
The user principal name (UPN) of the user. The UPN is an Internet-style login name for the user based on the Internet standard RFC 822. By convention, this should map to the user’s email name. The general format is alias@domain, where domain must be present in the tenant’s collection of verified domains. |
Photo Metadata class
Name | Path | Type | Description |
---|---|---|---|
Has photo
|
HasPhoto | boolean |
Has photo |
Height
|
Height | integer |
Height of photo |
Width
|
Width | integer |
Width of photo |
ContentType
|
ContentType | string |
Content Type of photo |
Image File Extension
|
ImageFileExtension | string |
File extension for the photo (ex: ".jpg") |
Class representing entity list response from an Office API.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of User |
Value |
@odata.nextLink
|
@odata.nextLink | string |
Next page link |
User from Graph API
Name | Path | Type | Description |
---|---|---|---|
About Me
|
aboutMe | string |
About Me |
Account enabled?
|
accountEnabled | boolean |
true if the account is enabled; otherwise, false. This property is required when a user is created. |
Birthday
|
birthday | date-time |
Birthday |
Business Phones
|
businessPhones | array of string |
Business Phones |
City
|
city | string |
The city in which the user is located. |
Company name
|
companyName | string |
The name of the company in which the user works. |
Country
|
country | string |
The country/region in which the user is located; for example, "US" or "UK". |
Department
|
department | string |
The name of the department in which the user works. |
Display Name
|
displayName | string |
Display Name |
Given Name
|
givenName | string |
Given Name |
Hire Date
|
hireDate | date-time |
Hire Date |
Id
|
id | string |
Id |
Interests
|
interests | array of string |
Interests |
Job Title
|
jobTitle | string |
Job Title |
Mail
|
string |
|
|
Nickname
|
mailNickname | string |
The mail alias for the user. This property must be specified when a user is created. |
Mobile Phone
|
mobilePhone | string |
Mobile Phone |
My Site
|
mySite | string |
My Site |
Office Location
|
officeLocation | string |
Office Location |
Past Projects
|
pastProjects | array of string |
Past Projects |
Postal code
|
postalCode | string |
The postal code for the user's postal address. The postal code is specific to the user's country/region. In the United States of America, this attribute contains the ZIP code. |
Preferred Language
|
preferredLanguage | string |
Preferred Language |
Preferred Name
|
preferredName | string |
Preferred Name |
Responsibilities
|
responsibilities | array of string |
Responsibilities |
Schools
|
schools | array of string |
Schools |
Skills
|
skills | array of string |
Skills |
State
|
state | string |
State |
Street Address
|
streetAddress | string |
Street Address |
Surname
|
surname | string |
Surname |
User Principal Name
|
userPrincipalName | string |
User Principal Name |
User Type
|
userType | string |
User Type |
This is the basic data type 'binary'.