Multiple Filtering in Outlook Mail Message

Hey everyone,

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

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

1 Like

Hi @jntrk
Can u try with this

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

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

Hi @jntrk ,

Can you try with this:

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

StrSubject is string variable…

1 Like

ıt works thank you

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.