Email Attachment file

[Sana_Afreen (Sana)]

Hi

I want to validate the format of email attachment. It should be in .xlsx format and the attachment should be only 1.

please help

[ppr (Peter Preuss)]

@Sana_Afreen
have a look here:

Count how many Excel attachements a MailMessage object has

@alvaro.j.nobre At least we can do. [grafik] With the help of Regex we can handle it more general for the different variations [grafik] Messages(0).Attachments.Where(Function (x) Regex.IsMatch(Path.GetExtension(x.Name).ToUpper,Pattern)).Count Modify the Patterns as by your needs /choice Use mail instead of Messages(0) in your code Ensure following: [grafik]

with an adoption give a try on:

YourMailVar.Attachments.Where(Function (x) Regex.IsMatch(Path.GetExtension(x.Name).ToUpper,".XLSX")).Count = 1

[Sana_Afreen (Sana)]

Sorry but I could’nt understand what to do here

[ppr (Peter Preuss)]

@Sana_Afreen
can you show some screenshots from the relevant part of your workflow

there schould be a part where the mail variable is to test. Above statement can be used within an if activity for checking if XLSX attachment is present or not

[Sana_Afreen (Sana)]

Thankyou for explaining. Let me try this

[Sana_Afreen (Sana)]

It worked for me. Thanks Alot. Can you explain what exactly has happened here?