Could you help me download and check files from an outlook email? and unzip file?

Goodmorning everyone,
can you help me with the following problem?
I have to read outlook emails and check if there is an excel file with a specific name inside (eg “Input.xlsx”) and check if there is also a zip file. If one of these two conditions is false then I just have to return an argument with false. Instead if these two conditions are true then I have to download all the attachments and unzip the zip file.
Finally I have to merge all the attachments that are in the unzip folder.

Thanks
Vittoria

hi @vittoria

  1. I have to read outlook emails and check if there is an excel file with a specific name inside (eg “Input.xlsx”)
    Get Outlook mail Message Activity in Properties you can have Filter option to check whether it is an Excel file or Zip file,

To check File name is “input.xlsx” or not you need to download it first after that only you can check.

I can help you in few points that download all the attachments and unzip the zip file

Please find the below workflow attached might help you.
Get_Outlook_MailAttachment.xaml (14.4 KB)

Thanks
Latika

1 Like

Hi @Latika10011740
i have this problem with your flow

image

do you think some package is missing?

thanks

image

Please check the packages used.

Thanks
Latika

1 Like

@Latika10011740
Thank you
It’s worked for me!

Happy automation

Best Regards,
Vrushali

1 Like