How to zip files with a certain extension and then delete those files

[Marta (Marta Miąsko - Office Samurai)]

Hi @Ishan_Shelke

First, you can create list of all files from your directory by using Directory.GetFiles method by:

Directory.GetFiles(strPathToFolderWithFiles, "*.xls").ToList()

Then, having those files saved in a list, you can create a separate folder and move all those files from the first folder, to the newly created one.

In the end, in order to create final .zip file, you can follow the following steps:

How to create a .zip file

Create a temporary folder(say TempFolder) to save your pdf files. Inside your for loop, use either move file or copy file activity to move your pdf files to the new location TempFolder. Now use invoke code activity and write the code “System.IO.Compression.ZipFile.CreateFromDirectory(TempFolder,ZipFilePath)”. Note that ZipFilePath and TempFolder should be “In” arguments for your invoke code activity. This should solve your problem.