How to filter by the current month with the Get Outlook Mail Messages activity

[Romario_Almeida]

Hello people,
How to filter only emails from the current month with the Get Outlook Mail Messages activity.
Can anyone help me with this?
Thank you.

[ghazanfar (Ghazanfar Ali)]

Use this in the filter it will give you the mails of current month

“[ReceivedTime] > '” + now.AddMonths(-1).tostring(“MM/dd/yyyy”) + “'”

Hope it will work

[1996 (Neelima G)]

Hi @Romario_Almeida,

Try this below code

"[ReceivedTime] >= ’ " +now.Month+ " ’ "

Thanks
Neelima.

[Romario_Almeida]

Hello @ghazanfar and @1996

Hello Ghazanfar
Thanks for the help, but I think it didn’t work very well, I only have 4 emails as unread and even so in the message box is coming 100, take a look at the attached image.

[1996 (Neelima G)]

@Romario_Almeida, As per my understanding your checking mail count but in properties you have mentioned as top 100.So, Instead of Top 100 can you change as 4.Hope this helps you.

Thanks!

[ghazanfar (Ghazanfar Ali)]

I have tested the code in my machine it is working fine. It does not matter how much value you enter into unread email count. see the below code and let me know in case of issue

Use this workflowEmail.xaml (4.8 KB)

[Romario_Almeida]

Hi @ghazanfar

This solution worked, thank you very much.

[ghazanfar (Ghazanfar Ali)]

Welcome