Unanswered

Get Email (v3) Search Query - setting time search

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,

I am trying to set Search Query in a way that I will get emails from specific folder that are one hour old. All emails that I get has the same same subject and body, but If I receive about 4 emails per hour I should ignore it, but if I receive 5 and more I need to pay attention to it.

This is some of samples that I made, but it is not working correctly:

I also tried this query:

received<=addHours(convertFromUtc(utcNow(),'GMT Standard Time'),1)

but it just gives me all the emails that I received before a past hour, but I need the one that I received in last hour.

I appreciate any help!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Hi @Anonymous ,

I don't believe that we need to convert utc datetime to local datetime because this action returns utc datetime.

So please try this:
received>=@{addHours(utcNow(),-1,'yyyy-MM-ddThh:mm:ss')}

Assuming the datetime now is 2022-10-11T11:42:30, it will return the emails between2022-10-11T10:42:30 and 2022-10-11T11:42:30.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-xiaochen-msft ,
That's perfectly works for me.
Thank you very much for the solution!

Best Regards,
Dilshod

Was this reply helpful? Yes No