web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Checking inbox for spe...
Power Automate
Unanswered

Checking inbox for specific emails

(0) ShareShare
ReportReport
Posted on by 23

Hi all,

I have now made a flow that automatically stores all incoming/outgoing emails and it updates the Excel sheet with the newest email. I store Subject, To, From, and Conversation ID in Excel. What I want to do now is another script that runs every 24h, to check if the emails still are in the inbox. If the email is not in the inbox, then I want it to write: "Completed" under status in my Excel sheet. What I am really having a hard time figuring out, is the best way to check the inbox for the specific email and report back with either "not found" or "found". Something like that at least.

Any ideas?

Categories:
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @PhillipDK  You can take subject from Excel and use Get Emails action (Supports top 25 emails only) compare subject from these two and update status in your excel column if subject is not found.

    Note: You need to compare unique value in both actions- List row present in a table & Get Emails.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • PhillipDK Profile Picture
    23 on at

    I have thought of this option too. What I am afraid of is, it is not only going to look in the "Inbox" but also the other folders I have. The idea is I archive the mails when they are done. So I only want it to look through the inbox, but it does not seem like you can specify that with the get emails action.

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @PhillipDK  you can select the folder in Get Emails.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • PhillipDK Profile Picture
    23 on at

    Arh I see. But that will not work as it is only the top 25 emails 😕

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @PhillipDK  This is the restriction from Microsoft. but You can increase frequency of your flow like each hour.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • PhillipDK Profile Picture
    23 on at

    Arh that sounds pretty smart. Can you give me an example?

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @PhillipDK Use recurrence trigger. Below flow will trigger each hour.

    Hardesh15_0-1673005890764.png

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

     

  • PhillipDK Profile Picture
    23 on at

    But won't that just look through the top 25 emails every hour? I want it to first list the values from my Excel and then compare one by one in the mailbox to check if it is there. So basically it would not matter how many emails I have in my Excel sheet, it should always work. Because there will be 100+ emails in my excel very soon.

  • VictorIvanidze Profile Picture
    13,083 on at

    Hi @PhillipDK ,

    add an additional column to your Excel table to save a message ID.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard