UiPath.Core.Activities.ForEachFileX

Executes an activity or a series of activities for each file in a specified folder. Use this activity when you are working with the files in a folder and you want to repeat one or more activities for each file. You then add the activities to repeat inside For Each File in Folder and, when you configure the input of the activities, you can indicate the file property to use for each file from the Current File entry in the menu.

The current file properties you can select in activities inside For Each File in Folder are Size (in bytes), Name (file name including extension), Full Path, Folder (full path to the folder containing the file), Last modified date, Last accessed date, Created date (dates including time), IsReadOnly (TRUE or FALSE), Size in KB. Depending on the activity, only some of the properties may be available for selection.

To learn how to use this activity, see:

• Tutorial: Working with Files and Folders.
• Tutorial: Saving, Renaming, and Moving Attachments.

In the Body of the Activity

• Folder - Click next to the field and then browse and select the folder that contains the files you want to work with. Alternatively, you can click 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 an application added to a card or from the Excel Workspace. 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 Excel Workspace.
  • Open in Advanced Editor - Enter a VB expression.
• Include sub-folders - If selected, also executes the activities on the files found in the child folders of the specified location. By default, this option is not selected.
• Filter by - Filters the files found in the specified folder. You can use * as wildcard (matches any number of characters). For example, you can filter only for pdf files using *.pdf as the filter. Click on the right side of the field, and then select Text to enter the filter in the Text Builder. Alternatively, you can use one of the other options in the menu to indicate the filter that you want to use:
  • Data from an application added to a card or from the Excel Workspace. For example, select an Excel file and then select a cell that contains a filter, or indicate a field from a selected email in Outlook that contains a filter.
  • Use Saved Value - Select text output from another activity that you previously saved for later use in the project.
  • Open in Advanced Editor - Enter a VB expression.
• Order by - Select from the drop-down menu in what order the files should be iterated through. You can order the files by name, created date, last updated date, and size, either ascending or descending.

Properties

Common

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

Input

• Filter - See Filter by in the body of the activity.
• Folder - See Folder in the body of the activity.
• IncludeSubdirectories - See Include sub-folders in the body of the activity.
• Order - See Order by in the body of the activity.

Misc

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