Answered

Get Emails V3 Received Date Time Format

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

It should be illegal how bad the documentation is on this connector.

Simple question I can't find after hours of searching: how do I search query for Received with Get Emails to hours minutes and seconds?

I found:

received<dd/MM/yyyy:HH:mm

but doesn't work.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Mister_Shaik 1,008 on at

Like (0)

Report
Copy link

Link copied!
Hi @benjaminwthomas ,

You can try using the standard dateTime format for this,
received:2022-04-19T01:51:56Z => yyyy-mm-ddThh:mm:ssz

If you want, you can remove the seconds, minutes or hours part as well, and it would still work!
received:2022-04-19T01:51Z or received:2022-04-19T01Z

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

Did not work, what's the greater than operator? Can you show me an example screenshot?

Was this reply helpful? Yes No
Mister_Shaik 1,008 on at

Like (1)

Report
Copy link

Link copied!
Hi @benjaminwthomas ,

The Search query input only searches for equality check - it does not support any other conditions like greater than or less than.

If you want to perform greater or less than operations -

1. You can use a HTTP action with graph APIs for filtering the emails,

https://graph.microsoft.com/v1.0/me/messages?$select=subject,receivedDateTime&$filter=receivedDateTime ge 2022-04-19T01:51:56Z

or

2. You can first get the emails for selected month and filter them in the flow itself using filter Action

"received:2022-04"

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

@Mister_Shaik that doesn't seem correct, see discussions like this: Get Emails V3 search query by receved date - Power Platform Community (microsoft.com)

Can you give an example of what the full API would look like populated in the connector?

Thanks for all the help!!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This seems to have been a connector/API issue as it has since resolved itself.

Was this reply helpful? Yes No