Query List

Use the Query List actionA tool for building the processes, logic, and direction within workflows. to query items in a specified SharePoint list in the current site. You can add conditions to limit the returned query results.

Query List is used to query lists in the current site only and if you want to query lists in different sites, the Office 365 query list action can be used.

Note: JSON results and OData queries: The Query List action uses Open Data Protocol (OData) query operations on the SharePoint list items in the current site. Data is retrieved in JSON format using the SharePoint REST service. For more information, see OData and SharePoint REST service.

Before you start 

Add and configure Query List action

In the Designer:

  1. Click the Libraries and Lists action group in the action toolbox.
  2. or

    Type the action name or function in the Search field at the top of the action toolbox.

  1. Drag the Query List action to the point in the workflow when you want to query a list.
  2. Open the Action Configuration window. For steps on how to open the Action configuration window, see Action configuration window
  3. Select a List item.
  4. Define the Maximum number of rows.
  5. Select an Output variable.
  6. Click Save.

For more information on the fields and buttons see, Query List fields, buttons and settings