How to filter the Email which are received today only

Hi Team,
I want filter the emails which are received today only. currently am using filter condition as "[ReceivedTime]>= ’ " +Now.Date.ToString but its not working. Could someone help me on this?

Hi @Srini_M

Can you try this one:

“[ReceivedTime] >= '” + DateTime.Today.ToString(“yyyy-MM-dd”) + “’ AND [ReceivedTime] < '” + DateTime.Today.AddDays(1).ToString(“yyyy-MM-dd”) + “'”

Hope this helps,
Best Regards.

Unable to retrieve the mails with this expression

Hi @Srini_M

Remove filter and give a try to this

@Srini_M

I tested the filter string & it is working for me. Please make sure you are using the same.

“[ReceivedTime] >= '” + DateTime.Today.ToString(“yyyy-MM-dd”) + “’ AND [ReceivedTime] < '” + DateTime.Today.AddDays(1).ToString(“yyyy-MM-dd”) + “'”

Output:

Let me know if any further assistance is required,
Best Regards.

Can you share the xaml if possible

filtered mails showing as Enumerable.WhereListIterator { ! … }

Hi @Srini_M ,

Check this below link to filter mailmessages with current date,

Hope this may help you :slight_smile:

3 Likes

@Srini_M

I hope you are using outlook mail messages, Please try this

[ReceivedTime] >= '" + DateTime.Today.ToString("d") + " 00:00AM'"

Else you have another option as well in modern activities you can use a for each email activity and you have filter option which you can select as you need

Hope this helps

cheers

Hi @Srini_M

Please find the requested Xaml:

Test3.xaml (7.6 KB)

Hope this helps,
Best Regards.

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