Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Translation Quality Feedback / Can I create a list of...
Power Automate - Translation Quality Feedback
Suggested answer

Can I create a list of the emails that I sent and received

(1) ShareShare
ReportReport
Posted on by CU16031229-0
Hello!!
 
It is recommended to me from the Microsoft community to post my question in the Power Automate community.
 
I am trying to speed up the process of recording (logging) what I am doing on a day to day basis. I receive and send maybe 30 / 40 emails a day. So, once the week is over can I create a list of the emails that I sent and received last week. The list ultimately will be placed in an MS Excel spreadsheet that will effectively work as a timesheet.
 
Thank you
Categories:
General
  • ronaldwalcott Profile Picture
    ronaldwalcott 3,530 on at
    Can I create a list of the emails that I sent and received
    Two flows with triggers

    One trigger “When a new email arrives” to capture incoming emails.
    Second trigger “When an email is sent” to capture outgoing emails.
     
    The flow extracts the subject and whatever other details you need and saves it to an excel sheet or first save it to a list then copy it to a sheet
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 41,072 Super User 2025 Season 1 on at
    Can I create a list of the emails that I sent and received
     
    Not sure if you have this working or not.
     
    But you really need 2 flows
     
    1. An Automated flow when when you receive an Email. It would be super simple
     
    but here are some things to do
    a) the excel sheet has to have an Excel Table around it OR you have to use Graph API from your Power Automate to log the data
    Assuming you had a table its a 2 action flow
    Receive email
     
    Use Add row to a Table and put the data into Excel
     
    2. You need another flow that will run on schedule and it will collect emails you sent. Since its more than 25 you would want to use this approach.
    In this cause you would use a reoccuring flow every day (i'd say at night)
    once it triggers follow this to grab the emails
     
    It will create a loop for you.
    Inside the loop is where you would use Add a row OR a Graph API call to add the data about your sent email(and with the loop aka Apply to each ) allows you to capture it
     
     
    If this helps you I'd appreciate if you Mark it as Such and maybe a like.
     
    If you need more help please come back :-)

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans