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.
Solved! Go to Solution.
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)"
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.
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....
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:
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)"
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.
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....
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: