Multiple Filtering in Outlook Mail Message

[jntrk]

Hey everyone,

I checked almost every topic regarding this question and still couldnt find a proper answer

I want to use 2 filters in my get outlook mail message activity, I have tried couple of ways but couldnt manage to work.

tried:
“[Subject]=‘test’ And [Received] >= " + DateTime.Today.ToString(“d”)”
and couple more but this is the latest one I tried.

What I need is to get mails with the subject, lets say ‘test’ and mails that recieved at the current day.

so filters are, subject and date

I appreciate every bit of help. Thank you

[NIVED_NAMBIAR (NIVED N)]

Hi @jntrk
Can u try with this

"[Subject]=‘test’ And [Received] >= " + DateTime.Today.ToString”

[jntrk]

[NIVED_NAMBIAR (NIVED N)]

Hi @jntrk

Can u try with assign activvity as below to do the filter operations

message_list = message_list.AsEnumerable().Where(Function(mail) mail.Subject.ToString.Equals(“test”) And mail.Headers("Date) >=Now.ToString)

where the message_list is the output of Get Outlook mail message activity

Regards

Nived N

Happy Automation

[Jan_Exner (Jan)]

Hi @jntrk ,

Can you try with this:

"@SQL=%today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject Like '%" + StrSubject + "%'"

StrSubject is string variable…

[jntrk]

@Jan_Exner

“@SQL=%today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject Like '%” + StrSubject + “%'”

ıt works thank you