For Each Folder in Folder

UiPath.Core.Activities.ForEachFolderX

Executes an activity or a series of activities for each child folder in a specified folder. Use this activity when you are working with child folders in a parent folder and you want to repeat one or more activities for each individual child folder. Add the activities to repeat inside For Each Folder in Folder and, when you configure the activities, select the file property to use for each folder from the CurrentFolder entry in the Plus menu.

Configuring the Activity

In the Body of the Activity

• For each - Enter the name by which to refer to the current folder in the iteration. Using a name that describes the folder makes it easier to identify and select the current folder option when configuring activities added inside For Each Folder in Folder. For example, for a folder that contains reports, you can enter Report. The default value is CurrentFolder.

• In folder - Click Browse next to the field, and then browse to and select the folder that contains the folders you want to work with. Alternatively, you can click Plus on the right side of the field and then, from the menu, choose one of the available options to indicate the folder path:

  • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file and then select a cell that contains a folder path, or indicate a field from a selected email in Outlook that contains a folder path.
  • Use Saved Value - Select a value in the form of a folder path that you previously saved for later use in the project.
  • Text - Enter a folder path in the Text Builder. You can combine text with a formula from an Excel file cell, for example to add a date to the folder name using formulas in the Project Notebook.
  • Ask when run - Prompt for a folder path when the project is executed.
  • Open in Advanced Editor - Enter a VB expression.
• Include subfolders - If selected, also executes the activities on the folders found in the child folders of the specified location. This option is not selected by default.
• Skip folders where access is denied - If selected, folders where the access is denied are automatically skipped. This option is not selected by default.

• Order by - Select from the drop-down menu in what order the folders should be iterated through. You can order the folders by name, created date, last updated date, and size, either ascending or descending.

  Note: If an error occurs due to the activity encountering a folder with limited access for the current user, selecting the Skip option in the error dialog skips the entire activity, not the folder with limited access.

In the Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• Filter by name - Filters child folders by name. Click Plus on the right side of the field and then, from the menu, choose one of the available options to indicate the folder path:

  • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file and then select a cell that contains a folder path, or indicate a field from a selected email in Outlook that contains a folder path.
  • Use Saved Value - Select a value in the form of a folder path that you previously saved for later use in the project.
  • Text - Enter a folder path in the Text Builder. You can combine text with a formula from an Excel file cell, for example to add a date to the folder name using formulas in the Project Notebook.
  • Paste from clipboard - Paste a value that you previously copied to the clipboard in the project.
  • Ask when run - Prompt for a folder path when the project is executed.
  • Open in Advanced Editor - Enter a VB expression.
• In folder - See the options in the body of the activity.
• Include subfolders - See the options in the body of the activity.
• Order by - See the options in the body of the activity.

Misc

• Private - If selected, the data used in the activity is not logged by StudioX.