cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mickow
Helper II
Helper II

Flow to record timestamps of emails sent (outlook)

Hi,
Is there a possibility to track in an excel file (preferably) what time were outlook messages sent? I want to create a flow to figure out how much time each task in the chain of tasks takes.
Each of those tasks requires sending an email - it would be the easiest to track those emails.
Also each chain of tasks (process) has its unique identifier in the subject of the email.
So the process looks like that:

PowerApp request -->Request recorded in the Excel Database-->Email Sent to DOER-->Task1-->Email sent to REVIEWER-->Task2-->Email sent to ADMIN--> Task3.

So I need timestamps for those 3 "Email sent to..." activities to be recorded in excel.

1 ACCEPTED SOLUTION

Accepted Solutions
ccc333ab
Solution Sage
Solution Sage

Not sure this will work for you but you could do the following:

 

1. Have your flow triggered from "When a new email arrives (V2)"

  • Change Folder to "Sent Items" so it'll only run when you send an email 
  • Update your Subject Filter to something that will recognize these specific emails...but there must be something that is consistent between ALL of these types of emails. You mention you have a unique ID in the subject line so that won't work. 

In my example below, I am assuming all my emails will have a preface of "[Test-". So that way I know all of these emails will pertain to this task....and after the dash, I will use the unique number. So something like [Test-0001], [Test-0002], etc. Hopefully there is something in your subject line that you can use. 

ccc333ab_0-1625842791509.png

 

2. Now you can just use the data from this trigger to store you date (use Received Time as that'll be the time the email gets received by your Sent folder).  I also am adding in Subject when I tested this....

ccc333ab_1-1625842918537.png

3. My test I ran a few emails, some with the subject line of [Test- and some without. Only the ones with the [Test- came through: 

ccc333ab_2-1625843106698.png

 

 

View solution in original post

1 REPLY 1
ccc333ab
Solution Sage
Solution Sage

Not sure this will work for you but you could do the following:

 

1. Have your flow triggered from "When a new email arrives (V2)"

  • Change Folder to "Sent Items" so it'll only run when you send an email 
  • Update your Subject Filter to something that will recognize these specific emails...but there must be something that is consistent between ALL of these types of emails. You mention you have a unique ID in the subject line so that won't work. 

In my example below, I am assuming all my emails will have a preface of "[Test-". So that way I know all of these emails will pertain to this task....and after the dash, I will use the unique number. So something like [Test-0001], [Test-0002], etc. Hopefully there is something in your subject line that you can use. 

ccc333ab_0-1625842791509.png

 

2. Now you can just use the data from this trigger to store you date (use Received Time as that'll be the time the email gets received by your Sent folder).  I also am adding in Subject when I tested this....

ccc333ab_1-1625842918537.png

3. My test I ran a few emails, some with the subject line of [Test- and some without. Only the ones with the [Test- came through: 

ccc333ab_2-1625843106698.png

 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,544)