Unanswered

Get Email(V3) Search Query for Month Filter

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm Trying to retrieve the Emails from the Outlook based on the Month. I have used the Get Email(V3) Search Query as " received le @{formatdatetime (adddays(utcnow(),-30),'dd/MM/yyyy')}. Even I tried with couple of things but I'm not able to achieve the Output what I Exactly Want. Please help me out. Thanks in Advance!..

Thanks & Regards,

Uvan.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous,

I am not sure if the search query parameter supports the le operator.

However, as a workaround you could use the Graph API instead with a filter query parameter. You can for example use that in a Send an HTTP request action from the Office 365 Groups connector..

Below is an example of that approach.

Btw, I would use a ge instead of an le because you everything from the last 30 days, correct? In this example I am only retrieving the receivedDateTime and subject of the individual e-mails. Remove that &select= part if you want to retrieve all properties 😁

https://graph.microsoft.com/v1.0/me/messages/?$filter=receivedDateTime gt @{addDays(utcNow(), -30, 'yyyy-MM-ddTHH:mm:ssZ')}&$select=receivedDateTime,subject

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

Like (0)

Report
Hi Expiscornovus,

Thanks for taking your time and it Worked for me as well.

Currently, I Achieved the thing in Get Emails(V3) action using Search Query as received<formatDateTime(adddays(utcnow(),-30),'yyyy-MM-dd'). Even though I liked your Approach which make my work Easy😀.
Is there any way to retrieve the 100+ Mails from the Particular folder/Subfolder using Send an HTTP Request action. If you have any workaround for this it will be great help for me. Thanks in Advance!..

Best Regards,
Uvan.

Was this reply helpful? Yes No