{"id":39187,"date":"2022-08-22T13:07:19","date_gmt":"2022-08-22T20:07:19","guid":{"rendered":"https:\/\/www.padtinc.com\/?p=39187"},"modified":"2024-03-05T17:05:28","modified_gmt":"2024-03-06T00:05:28","slug":"microsoft-flow-email-planner-task-notes","status":"publish","type":"post","link":"https:\/\/www.padtinc.com\/2022\/08\/22\/microsoft-flow-email-planner-task-notes\/","title":{"rendered":"Create a Microsoft Flow to Convert an Email Into a Microsoft Planner Task With Notes In 5 Steps"},"content":{"rendered":"\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

Editor’s Notes:<\/em>
(3\/5\/2024): Changed the “not flagged” to “Complete.” I was forgetting what emails I had flagged. So I changed it to “Complete.”
(3\/28\/2023): Added more details on how to format the output of the link to the emai<\/em>l and also added a final step to clear the flag.
(1\/27\/2023): Microsoft seemed to change the format for a link to the URL. So I updated Step 5 with the new format.<\/em><\/p>\n\n\n\n

I know this is not a normal topic for PADT’s blog, but I just updated my Microsoft Flow for converting an email into a task, and it took me a while to find an example of what I wanted to do. So I thought I’d share what I did to get it to work.<\/p>\n\n\n\n

Wait, You Need a Microsoft Flow For This?<\/h2>\n\n\n\n

Yup. In Microsoft Outlook Online, you can right-click on an email and make a ToDo task. But there is no way to do that in Outlook desktop or the mobile app, and it doesn’t make a planner task. And I use Microsoft Planner as my task management tool, not ToDo.<\/p>\n\n\n\n

The recommended solution to this shortcoming is to use a Microsoft Flow to take any flagged email and make a task. There are a ton of examples<\/a> for this on the interweb, and this served me well for a long time. The algorithm is:<\/p>\n\n\n\n

    \n
  1. Start the Microsoft flow when an “email is flagged” event happens<\/li>\n\n\n\n
  2. Get your user profile information <\/li>\n\n\n\n
  3. Create a task\n
      \n
    1. Use the email subject as the task subject<\/li>\n\n\n\n
    2. Put it in a bucket. I made one called “From Email” for this.\n
        \n
      1. Assign my Office365 User ID to assign the task to me<\/li>\n<\/ol>\n<\/li>\n\n\n\n
      2. Include a preview of the email body<\/li>\n\n\n\n
      3. Create a URL that links to the email in Outlook online<\/li>\n<\/ol>\n<\/li>\n\n\n\n
      4. Clear the flag<\/li>\n<\/ol>\n\n\n
        \n
        \"\" <\/picture><\/figure><\/div>\n\n\n

        But the Subject Alone was Not Enough<\/h2>\n\n\n\n

        This worked for me for more than a year. But I found that half the time I was working my way through the task list, the email’s subject string was not enough to remind me what I needed to do. What I wanted was to capture who it was from and the start of the content. And ideally, a link to the email.<\/p>\n\n\n\n

        And you can’t add this info to a task when you create it, you have to modify it. And that generated an error. <\/p>\n\n\n\n

        The secret was that you couldn’t just modify a Planner task after you make it. You have to give it some time to make its way into the cloud, then modify it. So you add a Delay, then add “Update task Details.”<\/p>\n\n\n\n

        Here is my Microsoft flow.<\/p>\n\n\n\n

        1. Start with a Flagged Email:<\/h3>\n\n\n
        \n
        \"\" <\/picture><\/figure><\/div>\n\n
        \n
        \"Microsoft <\/picture><\/figure><\/div>\n\n\n

        2. Get your ID with “Get my Profile.”<\/h3>\n\n\n
        \n
        \"Microsoft <\/picture><\/figure><\/div>\n\n\n

        3. Make the new task with “Create a task.”<\/h3>\n\n\n\n

        Use the subject from the email to identify the task. Note that I already made a “From Email” bucket in my primary ToDo Plan. You can also make a plan just for email-based tasks. While I was in there, I also set the start date to the date of the email to let me know when it came in. Last but not least, I use my Azure ID to assign the new task to me.<\/p>\n\n\n

        \n
        \"Microsoft <\/picture><\/figure><\/div>\n\n\n

        4. Wait for it to get stored with “Delay.”<\/h3>\n\n\n\n

        20 Seconds seems fine for me. Add more if it fails on you. This delay is critical to get the flow to work. If you don’t put the wait in, the information you need for future steps may not be in the cloud where you can get at it. <\/p>\n\n\n

        \n
        \"Microsoft <\/picture><\/figure><\/div>\n\n\n

        5. Add the info you want with “Update Task Details.”<\/h3>\n\n\n\n

        Here is where you can get fancy. Use the ID from the plan to tell the flow which task you want to modify. If “Id” doesn’t show up in the dropdown, scroll down on the dropdown and choose “Enter Custom Value,” and choose “Id.”<\/p>\n\n\n\n

        Then fill in the description with stuff you think you will need when you read the task in a few days. I use:<\/p>\n\n\n

        \n
        \"\" <\/picture><\/figure><\/div>\n\n\n

        That is a bit confusing, so here it is explained:<\/p>\n\n\n\n

          \n
        1. Task: Id\n