For Each File or Folder

UiPath.MicrosoftOffice365.Activities.Files.ForEachFileFolderConnections

Description

Iterates through a list of files and folders from OneDrive or SharePoint.

Add the activities to repeat inside For Each File or Folder and, when you configure the activities, select Use Variable > CurrentItem from the See more button menu to indicate that you want to repeat the actions for each item in the iteration. For details, see Iterate through items with For Each activities.

Note: This activity uses pagination for processing large numbers of items and mitigating performance issues.

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint - The connection for the Office 365 account to use in the activity.
• In location - The location where to search for files and folders. This field accepts IResource input.

Additional options

Options

• Limit to first - The maximum number of files and folder to return. If left blank, there is no limit. This field supports Int32 variables and Int32 values.
• What to return - The types of results to return: both files and folders, only files, only folders.
• Trim duplicates - Boolean value. Set to True to remove duplicate files and folders from the search results.
• Simple search - The query text used to search for files and folders across several fields (such as file name or file content). This property supports String variables and string formatted values. Use the Plus button menu to switch to Advanced search.

• Advanced search - An advanced search criteria defined to filter the files and folders. This advanced search is not supported for personal Microsoft accounts. Advanced search uses the Filter builder to configure the search criteria.

  • Include subfolders - Boolean value. Set to True to expand the search to all subfolders in the selected location.

Filtering limitations

• Filtering by File extension in the Filter builder might not work for extensions such as .avi, .svg, .gif, .ico, .jpeg, .jpg, .mov, .mp3, .mp4, .ogg, .png, .rtf, .tiff, .wav, .webm, .webp, or .wmv.
• Filtering by Last modified by or Shared with user might return incomplete results.
• The Graph API trims special characters from the beginning of a searched value. For example, if you search for "_Sorted", the API returns all files/folders whose name contains the word "Sorted", omitting the "_" character.
• When iterating through files in the OneDrive root folder using Advanced search without any filters configured and even when Include subfolders is False, the activity may return all OneDrive files instead of just the OneDrive root folder’s files only.

Output

• Number of items processed - The number of items processed by the activity.

Body

The body of the activity that stores other activities used in the automation.

Note:

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

• Send Email
• Write Row

Example

See also

• Files activities

• Get File List
• Share File/Folder
• Upload Files