Dela via


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.

Known Issues and Limitations

The followings are some of the known limitations of using Office 365 Users connector.

  1. 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.
  2. The connector does not support Government Community Cloud High (GCCH) accounts in LogicApps US Government Cloud.
  3. 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/*"
  4. 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.
  5. 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
  6. 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.
  7. 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 specifying Select 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.
  8. 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.
  9. Get my profile (V2) action may fail with 401 Unauthorized error when used by guest users. To workaround this, try specifying Select fields parameter explicitly to: id, displayName, givenName, surname, mail, mailNickname, accountEnabled, userPrincipalName, department, jobTitle, mobilePhone, businessPhones, city, companyName, country, officeLocation, postalCode.
  10. 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.

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

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.

Throttling Limits

Name Calls Renewal Period
API calls per connection 1000 60 seconds

Actions

Get direct reports (V1) [DEPRECATED]

This action has been deprecated. Please use Get direct reports (V2) instead.

Retrieves the user profiles of the specified user's direct reports.

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.

Retrieves the profile of the specified user's manager.

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.

Retrieves the profile of the current user.

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.

Retrieves the photo of the specified user if they have one.

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.

Retrieves the profile of a specific user.

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.

Retrieves the user profiles that match the search term.

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.

Get direct reports (V1) [DEPRECATED]

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

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

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

Get manager (V1) [DEPRECATED]

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

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

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

Get my profile (V1) [DEPRECATED]

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

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

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

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

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

Get user photo (V1) [DEPRECATED]

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

Get user photo (V2)

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

Get user photo metadata.

Parameters

Name Key Required Type Description
User (UPN)
userId True string

User principal name or id.

Returns

Photo Metadata class

Get user profile (V1) [DEPRECATED]

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

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

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

Search for users (V2)

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.

Search for users [DEPRECATED]

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

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.

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

Update my profile

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

Update my profile photo

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')

Definitions

GraphTrending

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

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

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"

LinklessEntityListResponse[List[Person]]

Represents a list from the Graph API

Name Path Type Description
value
value array of Person

Value

Person

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

ScoredEmailAddress

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.

Phone

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.

User

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
Mail 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.

ClientPhotoMetadata

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")

EntityListResponse[IReadOnlyList[User]]

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

GraphUser_V1

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
mail string

Mail

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

ObjectWithoutType

binary

This is the basic data type 'binary'.