I am get outlook activity

[VENKATESH2 (VENKATESH)]

i am using get outlook activity in this propeerty i need to filter in gamil. i need to for example “10-07-2024” and “15-07-2024” in the dates between 11,12,13,14. date i need to mails. so please give suggestion.i hope you all. provide to me filter code

[lrtetala (Lakshman Reddy)]

@VENKATESH2

am using get outlook activity in this propeerty i need to filter in gamil. i need to for example “10-07-2024” and “15-07-2024” in the dates between 11,12,13,14. date i need to mails. so please give suggestion.i hope you all. provide to me filter code

Hi @VENKATESH2

Try this

"@SQL=""urn:schemas:httpmail:datereceived"" >= '11-07-2024' AND ""urn:schemas:httpmail:datereceived"" <= '14-07-2024'"

Or

"[ReceivedTime] >= '11-07-2024' AND [ReceivedTime] <= '14-07-2024'"

Regards,

[vrdabberu (Varunraj Dabberu)]

Hi @VENKATESH2

You can use below Filter Expression:

"[ReceivedTime] >= '11/07/2024 00:00 AM' AND [ReceivedTime] <= '14/07/2024 11:59 PM'"

OR

=> Use the Get Outlook Mail Messages activity and store the result in the emails variable.

=> Use an Assign activity to filter the emails using the above LINQ query.

emailsFiltered = emails.Where(Function(mail) mail.Headers("Date") >= New DateTime(2024, 7, 11) AndAlso mail.Headers("Date") <= New DateTime(2024, 7, 14)).ToList()

Regards