SharePoint Online - Query user profile

Use the SharePoint Online - Query user profile action A tool for building the processes, logic, and direction within workflows. to retrieve user information from the SharePoint user profile database from a connected SharePoint Online tenant.

For example, you can automate interview - candidate information retrieval process using this action. The HR team may query on shortlisted candidate details to initiate the onboarding process.

Before you start 

Configure the SharePoint Online - Query user profile action

The steps required to configure the action are given below. The SharePoint Online - Query user profile action fields and settings table describes all the required and optional configuration fields.

  1. Select a Connection.

    Note: Only the connections created with the Administration authentication method are available in the drop-down. For more information about authentication methods for SharePoint Online connections, see Connectors.

  1. Type a User email address of the user profile that you want to query.

SharePoint Online - Query user profile action fields and settings

Section Field Description Variable types
(unlabeled)

Connection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The SharePoint Online connection to access the SharePoint Online tenant in which you want to perform the user profile query.

To refresh the available connections , click .

(n/a)
User

User email address

The email address of the user that you want to query.

Accepts either typed text or an inserted variable.

Boolean, Collection, DateTime, Decimal, Integer, Text

Output Result

Variable to store the queried user information.

Note: The variables in the object depend on the user profile properties that are set in your SharePoint Online site.

Object