For Each List Item

UiPath.MicrosoftOffice365.Activities.Sharepoint.ForEachListItemConnections

Description

Iterates through the items of a SharePoint list.

Scopes

This activity requires the following scopes:

• Sites.Read.All

OR

• Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.

• SharePoint list - Browse through SharePoint sites you follow and choose the SharePoint list to use for this activity. Click the Folder icon to browse available lists or use the See more button menu to switch to Enter Url input mode.

  • List Name or ID - Enter the name or ID of the list. This property supports String variables and string formatted values.
  • Site Url - Enter the Url of the site. This property supports String variables and string formatted values.

  • Select the Reload SharePoint List Picker option if you've updated your lists and need to retrieve the latest data.

  • Select the Update List Columns option if you've modified your lists and need to retrieve the latest data.

• Filter - Filter the items retrieved based on available SharePoint List columns.
• Columns to retrieve - Select which columns to retrieve from the SharePoint list.

Output

• Number of items processed - Total number of items processed. This variable can be used outside the For each list item activity.

Note:

Batching API calls is supported for the following activities when used inside the For each:

• Add List Item
• Send Email
• Update Single List Item

Example

See also:

• SharePoint Lists activities
• Add List Item
• Update Single List Item