Filter mail (outlook)

[fairymemay (noona)]

I want filter mail outlook.
I have value SenderEmail = ‘xyz@xyz.com
value Subject = Report

If I wanvalue t use filter in Get outlook mail messages.
How to code it?

Condition Filter mail that SenderEmail same value SenderEmail and SubjectMail contain Subject.

Please guide me about it.

[Srini84 (Srinivas Kadamati)]

@fairymemay

You may check below documentation

Get Outlook Mail Messages

Hope this may help you

Thanks

[fairymemay (noona)]

@Srini84 Yes.
But I don’t know how to pass variable in Filter Expression.

[lakshman (Ganta lakshman)]

@fairymemay

Try below expression in Filter field.

1. Filter mails from specific sender.

           "[SenderEmailAddress] = '"+varEmail+"'"
   

2. Filter mails based on specific subject.

            "[Subject] = '"+varSubject+"'"
   

Here varEmail and varSubject variables are of type String.

[muhamed.fasil]

You can use a for loop and an if condition using filter straight in the get outlook activity cant include conditions like contains ,starts with etc

so better to take the output of get mail activity and loop the activity with type argument as System.Net.Mail.MailMessage

[fairymemay (noona)]

@lakshman error as below.

[lakshman (Ganta lakshman)]

@fairymemay

It should be like below.

       "[SenderEmailAddress] = '"+fromEmail_Round1+"' AND [Subject] = '"+mailSubject_Round1+"'"

[nikhil.girish]

Hi @fairymemay
please find the below sample
Main.xaml (6.3 KB)
Thanks

[Steven_McKeering]

Hi @fairymemay

Further to @lakshman’s post.

Check out the screenshot below:

For the full list of filter examples check out the documentation here.

Cheers

Steve.

[fairymemay (noona)]

@nikhil.girish If I want use variable mailSubject_Round1 replace Report.

How to edit code?

[nikhil.girish]

Hi @fairymemay

"@SQL=urn:schemas:httpmail:subject LIKE '%"+mailSubject_Round1+"%'"

Thanks