Turn on more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
SharePoint

Retrieve All List Items from a SharePoint List

Important StatusThe current page has been customized from its template.
To retrieve all list items from a SharePoint list, complete the following steps:
  1. Check out and open the process you want to edit.

  2. In the Toolbox pane, click Microsoft SharePoint. A list of activities is displayed.

  3. Double-click or drag the Retrieve SharePoint List Items activity into the process.

  4. Link the activity appropriately with other activities in the process. 

  5. Right-click the Retrieve SharePoint List Items activity. A shortcut menu is displayed.

  6. Select View Properties. The Retrieve SharePoint List Items window is displayed.

  7. Click the List to Retrieve From tab. The corresponding screen is displayed.

  8. In the SharePoint Site field, click the System Resource editor icon. A drop-down list is displayed.

  9. 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.


  10. 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.


  11. Click the Retrieval Criteria tab. The corresponding screen is displayed.

  12. Select the Retrieve All Items in Specified List option.

  13. Click OK. You configured the activity to retrieve all list items from a SharePoint list.
Related Topics
Retrieve Specific List Items from a SharePoint List
Automatically Determine which Data Items to Populate with List Item Value
Manually Determine which Data Items to Populate with List Item Values
Download List Item Attachments to a Folder

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Microsoft SharePoint Activities > Retrieve SharePoint List Items
Last modified at 7/31/2020 11:54 AM