Get Outlook mail message want to filter with multiple condition

Help Studio
1

Get Outlook mail message want to filter with multiple condition

Received date from 28th June 2022 to till today and subject contains ‘Document’ and from ‘fghh@abc.com’

Could you please help me create this mail filter

2

im not sure how to filter by date but you could use an IF statement in a for each with the outlook messages

if item.subject.contains(“Document”) and item.from("fghh@abc.com)

3

Thanks for your suggestion. I want to use the filter option give in “Get Outlook mail message” Activity

For that i need this filter

4

Heyy!

Try this Filter

"[Received] >= '" + DateTime.Today.AddDays(-2).ToString("d")+"[Subject] = 'Document'"

Try this and let me know

Regards,
NaNi

5

Hi @Zara_Yasmin

Try this filter expression

"@SQL=(urn:schemas:httpmail:subject LIKE '%Document%') AND (urn:schemas:httpmail:fromname = 'John Doe') AND (urn:schemas:httpmail:datereceived >= '06/28/2022 00:00AM')"

from email is not working for me. That is why from name is used. If it works for you then try it.

"@SQL=(urn:schemas:httpmail:subject LIKE '%Document%') AND (urn:schemas:httpmail:fromemail = 'johndoe@mail.com') AND (urn:schemas:httpmail:datereceived >= '06/28/2022 00:00AM')"
6

BlankProcess12.zip (4.0 KB)
Please find attached to filter mails on date, subject and email id as requested.

7

fromemail is not working for me as well

1 Like
8

MailFilterbyDateSubjectAndEmail.zip (4.8 KB)
You can use attached workflow also