File name matches with value in excel send outlook email with pdf attachments

HI Community!

I’m Having doubt,

If file name matches with value in excel send outlook email with pdf attachments

I have a lot of PDF(Like, Certificates) placed in the folder and i have a list of email ID.

I want to send the particular PDF(Certificates) But i want to attach only pdf that matches filename with the value that i am getting from a excel sheet

Please any one guide me how to design the flow or please share the flow

Kindly assist.

Thank you

Hey @Rohith_Shastri ,

This sounds quite straight forward. You can have different ways to achieve this. I’ll explain one;

  1. Get the list of filenames from the folder using Directory.GetFiles() function
  2. Read the Excel file, loop through the rows
  3. For every loop, filter the list of filenames with the excel row value. If it provides a result, it should imply that the file exists with the same name.
  4. Mention the file path in the Send Outlook activity attachment section
  5. Continue the loop for all the rows in excel.

Let me know if you are not able to convert this into UiPath, I can create a workflow and send it to you.

Hi @Rohith_Shastri
please check this one.

SendEmailsOnValue.xaml (11.0 KB)

Screenshot In case of Studio Version Issue.