Get multiple Files in Folder and send it In Email

[Vincent_Nuestro]

Hi I just wanted to get multiple Files from a Folder and Store it in a string variable,

The problem is, after I get and Stored the list of String in One String using this strText = String.Join(“,”,strFilearr.toarray) It gives me the full path of Each Files, the reason why it throws some error.

I just wanted all files in one Folder and attached it in the email

Thank you, Please help me

Original thread.

How to Extract List of String into String Value

Hi Thanks @prasath_S @Yoichi , I Think I have another problem, Those List of Strings are Files in a folder and wanted to Get those files and attached in the email Using Invoke Code. [image] The problem is, after I Stored the list of String in One String using this strText = String.Join(“,”,strFilearr.toarray) It gives me the full path of Each Files, the reason why it throws some error. [image] I just wanted all files in one Folder and attached it in the email [image] Thank you, Please he…

[prasath17 (Guru)]

@Vincent_Nuestro - To get the filename alone…please try this code

String.join(",",New System.IO.DirectoryInfo(YourFolderPath).GetFiles().Select(Function(file) file.Name).ToArray())

or

String.join(",",Directory.GetFiles(YourFolderPath).Select(function(x) new fileinfo(x).Name).ToArray())

Hope this helps.

[Vincent_Nuestro]

Hi , What do you think is the problem? I used both of your code, and it gives me all the file name inside the folder. But im still getting error.

[prasath17 (Guru)]

@Vincent_Nuestro - please show us screenshot of the email activity ??

Basically, you just have to pass the array in the collection arguments…

[Vincent_Nuestro]

@prasath17
Here is my Invoke workflow activity

Here is the arguments of filepath

testPathAttach = String.join(“,”,Directory.GetFiles(MyFolderPath).Select(function(x) new fileinfo(x).Name).ToArray())

Arguments inside Invoke Code

[prasath17 (Guru)]

@Vincent_Nuestro - Sorry I haven’t tried invoke code method to send email…

[Nithin_P (Nithin Prabhu)]

Hi @Vincent_Nuestro ,

mail.Attachments.Add() → Takes a File Path. Hence if you want to add multiple files as attachment then you need the input argument to be (An Array of String) String[] and you will have to loop over this String[] and call the mail.Attachments.Add() method within the loop.

Hope that helps !

Thanks & Regards,
Nithin

[Eric_Wong_Test (Eric Wong)]

May be you can use this
ArrayString = System.IO.Directory.GetFiles(Directory Path)
Then, put the ArrayString into the Mail Activity (AttachmentsCollection)

[Vincent_Nuestro]

Hi, should be something like this?

[prasath17 (Guru)]

@Vincent_Nuestro - For Send Outlook mail message activity, this is how I configured…Here StrSummaryFiles is StrArray of all the summary files with simple directory.getfiles…

[Vincent_Nuestro]

Hi I already tried this method but it Didn’t work for me bcoz, I have email template in outlook (.oft file) and I must replace some data like <nickname, startdate, etc…> that the reason why i need to use invoke code activity. the data came from excel file and replace it in the email template.

Example of data needs to replace.

and im working on attachment of files im still getting errors

[Nithin_P (Nithin Prabhu)]

Hi @Vincent_Nuestro,

First perform the following to get the Files to be Attached in a String[]:
in_Attachments=Directory.GetFiles("<FolderPath>")

On Invoked Code Arguments change the AttachedFile Type from String to String[]. Next inside the code you can call a for each loop to loop through the String Array AttachedFile and within the loop add one file at a time to the mail object as follows:

Hope that helps !

Thanks & Regards,
Nithin