Filtering emails by multiple conditions "Get Outlook Mail Messages"

hey all

i need help filtering mails by:

  1. specific sender
  2. has attachments
  3. subject of the email contains only digits

thanks in advance

HI @Lior_Ben_Naim

For checking attachment
image

item.Attachments.Any

thank you, but i want to filter in the “Get Outlook Mail Messages” activity only

okay then check with the expressions in the link

Regards
Sudharsan

1 Like

Read the documentation? What an amazing idea.

1 Like

Hi @Lior_Ben_Naim

Can you share your Sample subject

@Lior_Ben_Naim

Try this expression

Get Outlook Message (Properties-> in filter use below expression)

"@SQL= urn:schemas:httpmail:hasattachment=true AND urn:schemas:httpmail:fromemail='Mail id you want'"

Regards
Sudharsan

Thank You @postwick

it appear that the condition is not valid

Hi @Lior_Ben_Naim

{"'[SenderEmailAddress] = 'Mail address' and @SQL= urn:schemas:httpmail:hasattachment=true'"}

Add ’ before[Sender… and check once

Regards
Sudharsan

Hi @Lior_Ben_Naim
I have updated the condition
Please check on it follow the steps mentioned

Also Find the Sample xaml file

outlook_mail_Filter.xaml (9.9 KB)

1 Like

still not working…
each segment work on its own…buy both together-> not working
any thoughts?

Have you tried with the workflow I shared
Because it’s working for me fine

no, it didn’t open very well.

is there another way to add more than one condition in the sintex?