SharePoint query list

Nintex external platform is required for this feature. For details, see Enable Nintex external platform features.

Queries a list in a SharePoint site.

Note: Not available for SharePoint 2007 sites.

Action settings

Following are the fields and options visible in the configuration settings dialog box for this action.

Section Field Description

(unlabeled)

 Destination site URL

The URL of the site where the list is located.

 

 List name

The name of the list to query.

 

 Query

Specify a query to select fields, query subfolders, add filters to the query, and specify sorting of returned items.

Select one of the following items for the query.

  • Query builder: Build a query to filter for items. View the CAML at any time by switching to the CAML Editor mode.
  • CAML editor: Create a more advanced query using XML encoding.

Fields: Specify fields for the query.

  • To add a field, click Add field.
  • To delete a field, click Delete ().

Include subfolders: When selected, queries for items within subfolders.

Maximum number of results: Specify the maximum number of rows to be returned by the query. Leave this field blank to return all results.

Filters: Select one of the following items.

  • Select all list items: Selects all items in the list or library.
  • Select items only when the following is true: Selects items based on column values.

    • Show the items when column / When column:: Specify a column, select an operator, and specify a value.

    • Add filter rule: Add a filter.
    • Delete (): Delete a filter. Displayed for second and subsequent filters.
    • And / Or: Specify how to group sequential filters.

Sort: Add one or more sort rules to specify the order in which to return the items.

  • First sort by column / Then sort by the column: Specify a column.
    • Show items in ascending order (A, B, C or 1, 2, 3): Select to sort in ascending order.
    • Show items in descending order (C, B, A or 3, 2, 1): Select to sort in descending order.
  • Add sort rule: Add a sort rule.
  • Delete (): Delete a sort rule. Displayed for second and subsequent rules.

Credentials

Authentication mode The mode to authenticate against the destination site.

 

 Username

Specify a username with permissions to query the list.

 

 Password

Specify the password for the above username.

 

Domain or SharePoint Online website domain

Specify the domain for the username if using Windows authentication mode, or specify the SharePoint Online domain URL if connecting to an Office 365 SharePoint Online site.

(unlabeled)

Output

Store output for this action using the following selections.

  • First column: Specify a collection workflow variable to store the first column values of the query results.
  • Fields XML: Specify a collection workflow variable to store the values from the query results.
  • Result count: The total number of results returned.

Depending on action requirements, you may be able to add and remove output variables.

To add an output variable

  1. Select an option from the Select more drop-down list.
  2. Click Add to display a drop-down list for the selected option.
  3. Select a previously defined workflow variable from the drop-down list.

To remove an output variable

  • Click Delete ().

    Note: Some output variables cannot be deleted. For example, the output variable URL for the action Bing news search cannot be deleted.