SharePoint Online - Retrieve an item

Use the SharePoint Online - Retrieve an item action A tool for building the processes, logic, and direction within workflows. to retrieve a specified item from a SharePoint Online list.

Before you start 

Configure the SharePoint Online - Retrieve an item action

The steps required to configure the action are given below. The SharePoint Online - Retrieve an item action fields and settings table describes all the required and optional configuration fields.

  1. Select a Connection.
  2. Note: 

    Only the connections created with the List and libraries authentication method will be available in the drop-down list.

    For more information about authentication methods for SharePoint Online connections, see Authentication methods for SharePoint Online connections.

  1. Type the SharePoint site URL that has the list with the list item you want to copy and click Retrieve lists.
  2. Example: https://domain.sharepoint.com/sites/hr

    All the lists in the specified site are displayed in the List name field drop-down list.

  1. Select the List name that you want to retrieve an item from.
  2. Caution: Querying and retrieving items from lists that contain 12 or more columns of the type - People, Lookup, or Managed Metadata, can cause a list view threshold error.

  1. Specify the Item ID of the item you want to copy. For information about how to get the Item ID, see Item ID.

SharePoint Online - Retrieve an item 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.

SharePoint Online connection to access the SharePoint Online site to use for the action.

To refresh the available connections, click Refresh.

(n/a)
Source item

SharePoint site URL

The URL of the SharePoint Online site that has the list or document library you want to use.

To retrieve the lists for the SharePoint site URL, type the SharePoint site URL and click Retrieve lists.

Example: https://domain.sharepoint.com/sites/hr

Text, Decimal, Integer, Boolean, DateTime, Collection

 

List name

The list that has the item you want to retrieve.

The lists and document libraries within the site specified in SharePoint site URL are displayed in the drop-down list.

Text, Decimal, Integer, Boolean, DateTime, Collection

  Item ID

The ID of the list item you want to retrieve.

Integer
Output Result

Store the result of the action in an object that has all the columns in the selected SharePoint list.

Note: 

If the selected list has Lookup type columns with secondary columns, the secondary columns will be available as String (Text) data type variables in the output object.

Object