How do I process multiple files in a directory with a single execution of a flow?

To process files in a directory, the File System Items Source object is used. This object is available in dataflows, workflows and API flows. File System Items Source takes the path of a folder or directory and executes the object connected to its output for every file in the directory, when configured as a ‘loop’.

For processing multiple files in a dataflow, file source objects, such as Delimited File Source, and Excel File Source, can be used as a transformation object, and the input file path can be provided dynamically for all the files in a folder using the File System Item Source object.

Click here to learn how File System Items Source is used in a dataflow and workflow.