Get Outlook mail message Filter

[ppr (Peter Preuss)]

so todays emails are emails within the range of
>now.AddDays(-1) 23:59 And < now.AddDays(1) 00:00
Or

>= now 00:00 and <= now 23:59

[Dmitri00007 (Dmitri)]

“@SQL=(” + “”“” + “urn:schemas:httpmail:datereceived” + “”“” + " >= ‘“+“dd.MM.yyyy hh:mm tt”+”’)"

Try to use this

[Vishnu_Reddy1 (Vishnu Reddy)]

hi Peter
Tq for helping this

It’s not working…

[ppr (Peter Preuss)]

from our tests we can agree to @Dmitri00007 that provided filter approach was working instead of [Reveived] and its variations

As we filtered direct to a single email (described above) and then enlarged the filter period (also described above) we quickly found out the working filter statement. So, we would also recommend to do a dame RnD.

In case of you feel that there is bug then just provide all details

• Studio Version
• Package Versions: UiPath.System.Activities, UIPath.Mail.Activities
• Details to the implementation
• selected targetframework
• C# or VB.Net usage

So others can try to replicate or give feedback on its success on the test

[Vishnu_Reddy1 (Vishnu Reddy)]

Hi PPR
Tq for helping me.

Studio Version is 2022.4.4
Packages

Versions: UiPath.System.Activities v22.4.4

UIPath.Mail.Activities v1.16.0

Details to the implementation

selected targetframework

VB.Net

[ppr (Peter Preuss)]

@Vishnu_Reddy1
we did the 1 replication RnD round and will inspect next the behaviour. Currently we identified a non working scenario.

[ppr (Peter Preuss)]

give a try for RnD purpose on hardcoded filter

set Top=30
"( ([ReceivedTime] > '10/08/2022') AND ( [ReceivedTime] < '12/08/2022' ) )"

when it is returning yesterdays mail delete top = 30
run again

repeat two tests again for
set Top 30
"( ([ReceivedTime] > '08/10/2022') AND ( [ReceivedTime] < '08/12/2022' ) )"

when it is returning yesterdays mail delete top = 30
run again

Let us know the results

Kindly note we were able to get the emails, but our local format is dd/MM/yyyy. So regardless which local format is in use at your end we would like to find any triggers when it is working and when it is failing