web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Email(V3) Search Q...

Power Automate

Answered

Get Email(V3) Search Query for Month Filter

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation