Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get Emails V3 Received Date Time Format

(0) ShareShare
ReportReport
Posted on by

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.

  • Verified answer
    Re: Get Emails V3 Received Date Time Format

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

  • Re: Get Emails V3 Received Date Time Format

    @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!!

  • Mister_Shaik Profile Picture
    Mister_Shaik 1,006 on at
    Re: Get Emails V3 Received Date Time Format

    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.

  • Re: Get Emails V3 Received Date Time Format

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

  • Mister_Shaik Profile Picture
    Mister_Shaik 1,006 on at
    Re: Get Emails V3 Received Date Time Format

    Hi @benjaminwthomas ,

     

    You can try using the standard dateTime format for this,

    received:2022-04-19T01:51:56Z => yyyy-mm-ddThh:mm:ssz

    1. date format.PNG

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard