Files Loop Dynamic Action

About

The Files Loop Action iterates through the list of files, file name is assigned to #LoopValue# variable.

Metadata tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. This option is typically used for debugging and is not recommended in a production environment.
3. It can be globally disabled through the options dialog .

Parameters tab

N Value Parameter

The meaning of N Value parameter depends on Which File Parameter

1. When Which File Parameter is equal to “Files Not Older Than N Days” N Value is Days
2. When Which File Parameter is equal to “Files Older Than N Days” N Value is Days
3. When Which File Parameter is equal to “First N Found Files” N Value file number
4. When Which File Parameter is equal to “Bigger Than N Bytes” N Value is byte

Resuming Loop Execution After Failure

1. When Resume Loop is true current loop position value is saved into Loop Position File automatically
2. The same file is used to resume file execution after failure
3. Upon successful completion the Loop Position File is deleted

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Related Actions

1. IMAP4 Email Loop Action
2. Office 365 Email Loop Action
3. File Loop Action
4. Database Loop Action
5. Down Loop Action
6. Up Loop Action
7. Json Object Loop Action
8. Json Array Loop Action

Useful Links

• Debugging Actions
• Working With Variables

Problem description

• Excel files are received via email.
• Each file contains only one sheet.
• Sheet names vary.
• The sheet must be renamed to “DATA”.

Solution

Since each file has only one sheet, the simplest approach is to to save list of sheets into a file, store it in a variable, and use ths variable as Old Sheet parameter

Video Tutorial