BPM5 Documentation - Retrieve Specific List Items from a SharePoint List

To retrieve specific list items from a SharePoint list, complete the following steps:

Check out and open the process you want to edit.
In the Toolbox pane, click Microsoft SharePoint. A list of activities is displayed.
Double-click or drag the Retrieve SharePoint List Items activity into the process.
Link the activity appropriately with other activities in the process.
Right-click the Retrieve SharePoint List Items activity. A shortcut menu is displayed.
Select View Properties. The Retrieve SharePoint List Items window is displayed.
Click the List to Retrieve From tab. The corresponding screen is displayed.
In the SharePoint Site field, click the System Resource editor icon. A drop-down list is displayed.
Select the appropriate SharePoint system resource. The selected system resource’s name is displayed in the field.

Note:

If your system resource contains a data item, click Configuration values and enter a valid URL and credentials for design-time, configuration purposes.
In the SharePoint List field, select the appropriate input field editor and set the field to a value that is the list name that you want to retrieve.

Note:

If your system resource contains a data item in the connection string property, click Configuration values and enter a valid connection string for design-time, configuration purposes.
Click the Retrieval Criteria tab. The corresponding screen is displayed.
Select the Retrieve List Items That Meet the Following Criteria option.
Select the criteria you want to use to retrieve SharePoint list items from the following options:

    Retrieve list items that meet all of the following criteria
    Retrieve list items that meet one or more of the following criteria
    Retrieve list items that do not meet all of the following criteria
    Retrieve list items that do not meet one or more of the following criteria
In the List Column field, click the drop-down arrow. A drop-down list of is displayed.
Select the appropriate SharePoint list column. The selected list column’s name and the corresponding data type are displayed in the respective fields.
In the Filter Condition field, select the relevant operator for the criteria you want to apply.
In the Value to filter on field, select the appropriate input field editor and set the field to a value on which you want to apply the filter
Click OK. You configured the activity to retrieve specific list items from a SharePoint list.

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Microsoft SharePoint Activities > Retrieve SharePoint List Items

Last modified at 7/31/2020 11:57 AM

Retrieve Specific List Items from a SharePoint List // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>

Retrieve Specific List Items from a SharePoint List