To-do! Assigning due dates based on e-mail importance
I recently read this blog post from Luis Freese about Microsoft To-do - 11 reasons why I fell in love with Microsoft To-Do and I couldn't agree more. In-fact, I can add 10 more to that list!
One of the reasons mentioned was around moving flagged e-mails to To-Do using Microsoft Flow . To take this a step further, I wanted a way to assign due dates and reminders for the e-mails based on some priority level. Below is a step-by-step approach to achieve this -
Note: This applies only for desktop Outlook
- Step 1: Create Outlook shortcuts to flag an e-mail and assign an importance level.
Open Quick Steps in Microsoft Outlook
Click on 'New' or if you already have a configured quick step, click on 'Edit'
Click on "Add Action" and choose "Set Importance" action and then select the Importance level from the drop down. Also, select the shortcut key so that you can assign the quick step from your keyboard.
Similarly, set up shortcuts for the 3 different levels of Importance. Choose the shortcut keys wisely! For the High Importance I chose the "Ctrl+Shift+1", for Medium Importance - "Ctrl+Shift+2" and for Low Importance - "Ctrl+Shift+3".
So now you can use these shortcuts to quickly assign an importance level and flag the e-mails.
- Step 2 - Set up the Flow in Microsoft Flow to assign the flagged e-mail as a task in To-Do with a due date based on the Importance. (Download the Flow files from here)
Start with the trigger "When an email is flagged" and then initialize a variable to store the number of days before due date.
Based on the 'Importance' value from the e-mail, set the DueDays variable value. Personally, I wanted to set High Importance - 1 day, Medium Importance to 3 days and Low Importance to 5 days. For e-mails where I don't set the importance level, I set the value to 7 days.
Now, add the "Add a to-do" action and set the values as defined above. You can customize it based on your liking. Remember to set the body content type to HTML to have a nice looking e-mail in the note of the to-do. For due date and reminder, use the expressions as defined below.
Due date expression - addDays(utcNow(),variables('DueDays'))
The expression above adds the number of days before the task is due to the current time.
Reminder date time expression - addDays(utcNow(),sub(variables('DueDays'),1))
The expression above reduces the number of due days by 1 day and adds it to the current time, so you can get the reminder 1 day before the task is due. Of-course, you can customize this as well to your liking.
- Step 3 - Sit back and enjoy!
Bonus tip -
When you try adding emojis to be used as an icon for a List category, you get very limited options. If you want to use some other emoji, try out the method described below. To get the emoji menu in Windows 10 press "Windows key + ;" . You can also search for emojis from this menu. In my case, I searched for 'target" and got the emoji I wanted.
Have fun using To-Do!
Download the Flow files from here
Thanks
Vivek Bavishi / That API Guy
*This post is locked for comments