Create a Microsoft Flow to Convert an Email Into a Microsoft Planner Task With Notes In 5 Steps

Microsoft Flow for Email to Planner Task
Categories:

Editor’s Notes:
(3/28/2023): Added more details on how to format the output of the link to the email 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.

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.

Wait, You Need a Microsoft Flow For This?

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.

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 for this on the interweb, and this served me well for a long time. The algorithm is:

  1. Start the Microsoft flow when an “email is flagged” event happens
  2. Get your user profile information
  3. Create a task
    1. Use the email subject as the task subject
    2. Put it in a bucket. I made one called “From Email” for this.
      1. Assign my Office365 User ID to assign the task to me
    3. Include a preview of the email body
    4. Create a URL that links to the email in Outlook online
  4. Clear the flag
2023 03 28 22 02 20

But the Subject Alone was Not Enough

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.

And you can’t add this info to a task when you create it, you have to modify it. And that generated an error.

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.”

Here is my Microsoft flow.

1. Start with a Flagged Email:

image 32
Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 1

2. Get your ID with “Get my Profile.”

Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 2

3. Make the new task with “Create a task.”

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.

Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 3

4. Wait for it to get stored with “Delay.”

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.

Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 4

5. Add the info you want with “Update Task Details.”

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.”

Then fill in the description with stuff you think you will need when you read the task in a few days. I use:

image 31

That is a bit confusing, so here it is explained:

  1. Task: Id
    • This is the internal Id of the task you just created and waited for
  2. Email: From
    • From the email that triggered the flow, the email on the From line
  3. Expression: decodeUriComponent(‘%0A’)
    • To get a new line of text, you have to use this function to create a unicode linefeed character
  4. Expression: decodeUriComponent(‘%0A’)
    • Do it again to get a blank line
  5. Email: Body Preview
    • Gives the first bunch of characters in the email instead of the whole body
  6. Expression: decodeUriComponent(‘%0A’)
    • Line Feed
  7. Expression: decodeUriComponent(‘%0A’)
    • Line feed
  8. Text: https://outlook.office365.com/owa/?ItemID=
    • This is the first part of the URL needed to point to a message in the browser version of outlook.
  9. Email: Message Id
    • Internal Id for the triggering email.
  10. &exvsurl=1&viewmodel=ReadMessageItem
    • Arguments telling Outlook web interface to use the ID and open it for reading.

Now, if you want to get fancy, you could save the email message to a file on OneDrive, then put the link to the message in the Reference section. Sounds like a pain, and I’d rather deal with the email in Outlook.

6. Clear the Flag with “Flag email (V2)”

Now that the task is created in planner, you should clear the flag on the email.

Do that with a Flag email (V2) step. I renamed it “Clear Flag.” Set the Message Id to the ID for your message and then set Flag Status to “Not flagged”

2023 03 28 22 06 33

Check Out Your Shiney New Task

Here is what it looks like on my Plan:

image 34

And if I click on the task, I can see the information I want and the URL:

image 36

Give It a Try

I’ve not tried to share a flow outside of my organization before, but here is a zip file you can try and import:

Use at your own risk, etc…

While You are Here

I’m not sure how you ended up on PADT’s website, but if you happen to be a mechanical engineer or similar, check us out. We are an Ansys Elite Channel Partner, A Stratasys Diamond Partner, and one of the most respected providers of simulation, design, and 3D Printing services in the US. If any of those words mean something to you, contact us and let us know how we might be able to help. I’ll even flag your email so it shows up as a task in planner.

And if all of that engineer talk is goblidy gook, that is fine too. I’m glad we might have been able to help you.

We Make Innovation Work | PADT
Categories

Get Your Ansys Products & Support from the Engineers who Contribute to this Blog.

Technical Expertise to Enable your Additive Manufacturing Success.

PADT’s Pulse Newsletter

Keep up to date on what is going on at PADT by subscribing to our newsletter.


By submitting this form, you are consenting to receive marketing emails from: . You can revoke your consent to receive emails at any time by using the SafeUnsubscribe® link, found at the bottom of every email. Emails are serviced by Constant Contact

Share this post:

Upcoming Events

09/27/2023

2023 AZ Bio Awards

09/26/2023

Experience Stratasys Truck Tour - Houston

09/22/2023

AIAA Rocky Mountain Section Technical Symposium 2023

09/22/2023

Experience Stratasys Truck Tour - Dallas, TX

09/21/2023

Accelerating the Energy Transition through Simulation

09/20/2023

3D Printing vs. CNC Machining - Webinar

09/13/2023

Maxwell Updates in Ansys 2023 R2 - Webinar

09/12/2023

Sandia Science & Technology Park 25th Anniversary

09/12/2023

Experience Stratasys Truck Tour - Tempe, AZ

09/08/2023

26th Annual New Mexico Flying 40 Awards

09/08/2023

New Mexico Tech Summit

09/07/2023

New Mexico Tech Summit

08/30/2023

Structures Updates in Ansys 2023 R2 (1) - Mechanical, Post & Graphics

08/23/2023

Improved Injection Molding with Additive - Webinar

08/22/2023

SPIE Optics & Photonics Exhibition 2023

08/16/2023

Fluids Updates in Ansys 2023 R2 - Webinar

08/04/2023

Experience Stratasys Truck Tour - Salt Lake City, Utah

08/01/2023

Experience Stratasys Truck Tour - Denver Colorado

07/26/2023

Solving Supply Chain Issues with Additive - Webinar

07/25/2023

Arizona Tech Leadership Golf Tournament

07/24/2023

Arizona Tech CEO Leadership Retreat

07/19/2023

System Automation & Optimization Updates in Ansys 2023 R1 - Webinar

07/13/2023

2023 AEROSPACE, AVIATION, DEFENSE AND MANUFACTURING CONFERENCE

07/12/2023

Materials Updates in Ansys Granta 2023 R1 - Webinar

06/30/2023

Turbo Expo 2023

06/29/2023

Turbo Expo 2023

06/28/2023

Turbo Expo 2023

06/28/2023

Revolutionize Packaging Design with Additive - Webinar

06/27/2023

Turbo Expo 2023

06/27/2023

2023 E-MOBILITY AND CLEAN ENERGY SUMMIT

06/26/2023

Turbo Expo 2023

06/21/2023

Optics Updates in Ansys 2023 R1 - Webinar

06/07/2023

LS-DYNA Updates in Ansys 2023 R1 - Webinar

05/31/2023

Driving Automotive Innovation with Additive - Webinar

05/24/2023

Hill Air Force Base Tech Expo

05/24/2023

Structural Updates in Ansys 2023 R1 (3) – Structural Optimization & Ex

05/23/2023

CROSSTALK 2023: Emerging Opportunities for Advanced Manufacturing Smal

05/10/2023

Signal & Power Integrity Updates in Ansys 2023 R1 - Webinar

04/26/2023

Additive Manufacturing Updates in Ansys 2023 R1 - Webinar

04/20/2023

38th Space Symposium Arizona Space Industry

More Info

04/19/2023

38th Space Symposium
Arizona Space Industry

04/19/2023

Additive Aids for Manufacturing - Webinar

04/18/2023

38th Space Symposium
Arizona Space Industry

04/17/2023

38th Space Symposium

04/13/2023

Venture Madness 2023

04/12/2023

Fluid Meshing & GPU-Solver Updates in Ansys 2023 R1 - Webinar

03/29/2023

8th Thermal and Fluids Engineering Conference

03/29/2023

Structural Updates in Ansys 2023 R1 - Composites, Fracture & MAPDL

03/28/2023

8th Thermal and Fluids Engineering Conference

03/27/2023

8th Thermal and Fluids Engineering Conference

03/26/2023

8TH Thermal and Fluids Engineering Conference

03/24/2023

Arizona BioPreneur Conference | Spring 2023

03/22/2023

2023 Arizona MedTech Conference

03/22/2023

Optimize Jigs & Fixtures with Additive - Webinar

03/15/2023

3D Design Updates in Ansys 2023 R1 - Webinar

03/08/2023

Competitive Advantages of 1D/3D Coupled Simulation - Webinar

03/01/2023

High Frequency Updates in Ansys 2023 R1 - Webinar

02/22/2023

Additive Advantages in Aerospace - Webinar

02/15/2023

Structural Updates in Ansys 2023 R1 (1) - Webinar

02/09/2023

IME 2023: MD&M | WestPack | ATX | D&M | Plastek

02/08/2023

IME 2023 MD&M | WestPack | ATX | D&M | Plastek

02/07/2023

IME 2023 MD&M | WestPack | ATX | D&M | Plastek

01/27/2023

Arizona Photonics Days, 2023

01/26/2023

Arizona Photonics Days, 2023

01/26/2023

TIPE 3D Printing | 2023

01/26/2023

Venture Cafe Phoenix Talent Night - Job Fari

01/26/2023

VFS 2023 Autonomous/Electric VTOL Symposium

01/25/2023

Arizona Photonics Days, 2023

01/25/2023

Building A.M.- Utah: Kickoff!

01/25/2023

TIPE 3D Printing | 2023

01/25/2023

VFS 2023 Autonomous/Electric VTOL Symposium

01/24/2023

VFS 2023 Autonomous/Electric VTOL Symposium

01/24/2023

TIPE 3D Printing | 2023

01/18/2023

2023 AZ Tech Council Golf Tournament

12/21/2022

Simulation Best Practices for 5G Technology - Webinar

12/14/2022

Digital Twins Updates in Ansys 2022 R2 - Webinar

12/08/2022

Tech the Halls - AZ Tech Council Holiday Mixer

12/07/2022

Electric Vehicle and Other Infrastructure Update Panel

11/30/2022

SPEOS Updates in Ansys 2022 R2 - Webinar

11/23/2022

Simulation Best Practices for Electronics Reliability - Webinar

11/16/2022

Discovery Updates in Ansys 2022 R2

11/10/2022

VentureCafe Phoenix Panel: Venture Capital in AZ

11/08/2022

2022 GOVERNOR’S CELEBRATION OF INNOVATION AWARDS + TECH SHOWCASE

11/03/2022

VentureCafe Phoenix Panel: Angel Investment in AZ

11/02/2022

High & Low Frequency Electromagnetics Updates in Ansys 2022 R2

10/26/2022

Simulation Best Practices For Chip-Package-System Design & Development

10/20/2022

Nerdtoberfest 2022

10/19/2022

2022 Southern Arizona Tech + Business Expo

10/19/2022

LS-DYNA Updates in Ansys 2022 R2 - Webinar

10/17/2022

Experience Stratasys Truck Tour - Clearfield Utah

10/14/2022

ASU School of Manufacturing Systems and Networks - Formal Opening Cele

10/14/2022

Experience Stratasys Truck Tour - Midvale Utah

10/12/2022

Experience Stratasys Truck Tour - Littleton Colorado

10/06/2022

Fluids Updates in Ansys 2022 R2 - Webinar

10/05/2022

Experience Stratasys Truck Tour - Colorado Springs

09/29/2022

White Hat Life Science Investor Conference - 2022

09/28/2022

2022 AZBio Awards

09/28/2022

Simulation Best Practices for Rotating Machinery Design & Development

09/21/2022

ExperienceIT NM 2022

Search in PADT site

Contact Us

Most of our customers receive their support over the phone or via email. Customers who are close by can also set up a face-to-face appointment with one of our engineers.

For most locations, simply contact us: