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.

For more information about the SharePoint Online connector, go to SharePoint Online.

Before you begin: 

Jump to:

Configure the SharePoint Online - Query user profile action

Important: Before inserting variables in the action configuration, you must manually type or select the values and populate other dependent fields in order to retrieve the output data. Once configured, you can insert variables to the required fields.

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add, rename, and copy actions.

  2. Select a SharePoint Online Connection. If you do not have a connection, see Add 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 Authentication methods for SharePoint Online connections.

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

SharePoint Online - Query user profile action fields and settings

Important: Before inserting variables in the action configuration, you must manually type or select the values and populate other dependent fields in order to retrieve the output data. Once configured, you can insert variables to the required fields.

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