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
By: Eric Miller
– August 22, 2022
Categories:

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.

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
  2. Get your profile information
  3. Create a task
    1. Use the email subject as the task subject
    2. Put it in a bucket I made called “From Email”
      1. Assign my Office365 User ID to assign the task to me

But the Just Subject was Not Enough

This worked for me for more than a year. But I was finding that half the time I was working my way through the task list, the email’s subject 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.

The secret was that you couldn’t just modify a Planner task. You have to give it some time to make its way into the cloud, then modify it. So you add a Delay, then and Update task Details.

Here is my Microsoft flow.

1. Start with a Flagged Email:

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

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. If it 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:

  • I start by giving the person’s email address so I know who it is from
  • Then a couple of newlines with decodeUriComponent(‘%0A’) functions (Use Expression and enter the string, then click “Update”)
  • I then put in the Body Preview. This is the start of your Email that Outlook would show, as text. The Body itself could be HTML and it comes across that way. So use Body Preview
  • More newlines
  • Then I put in a link to the email in Outlook.
    • ​https://outlook.office365.com/mail/deeplink?ItemID= with Message Id appended
Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 5

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.

Here is what it looks like on my Plan:

Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 6
And if I click on it.
Microsoft Flow to Convert Flagged Email to a Planner Task, Figure 7

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…

Still more to Do with this Microsoft Flow

One thing I didn’t find out how to do was add a comment, but I think this description is good enough.

The big problem with this whole approach is when you reply, if you don’t remove the flag first in Outlook, it the Microsoft Flow will make a new task. If I had time, I’d check the list of tasks in this bucket and make sure it’s not a duplicate. But hey, for another day. If you are like me, you could spend hours playing with Microsoft Flows, well beyond their adding any additional value.

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 it’s all goblidy gook, that is fine too. I’m glad we might have been able to help you.

We Make Innovation Work | PADT
Categories

Certified Elite Channel Partner

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

Product Development
Diamond Partner

Technical Expertise to Enable your Addictive 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: Phoenix Analysis and Design Technologies, 7755 S. Research Dr., Tempe, AZ, 85284, https://www.padtinc.com. 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:

Share on twitter
Share on facebook
Share on linkedin
Share on pinterest

Upcoming Events

09/21/2022

ExperienceIT NM 2022

09/21/2022

Additive Updates in Ansys 2022 R2 - Webinar

09/14/2022

Rocky Mountain Life Sciences Investor & Partnering Conference

09/08/2022

Ansys Optics Simulation User Group Meeting - Virtual

09/08/2022

Ansys Optics Simulation User Group Meeting

09/07/2022

SI & PI Updates in Ansys 2022 R2 - Webinar

08/31/2022

Simulation Best Practices for Developing Medical Devices - Webinar

08/24/2022

Mechanical Updates in Ansys 2022 R2 - Webinar

08/10/2022

Tucson after5 Tech Mixer: Ruda-Cardinal

08/05/2022

Flagstaff Tech Tour, 2022

08/02/2022

2022 CEO Leadership Retreat

08/01/2022

2022 CEO Leadership Retreat

07/27/2022

Thermal Integrity Updates in Ansys 2022 R1 - Webinar

07/20/2022

Simulation Best Practices for the Pharmaceutical Industry - Webinar

07/14/2022

NCMS Technology Showcase: Corpus Christi Army Depot

07/13/2022

NCMS Technology Showcase: Corpus Christi Army Depot

07/13/2022

Additive & Structural Optimization Updates in Ansys 2022 R1 - Webinar

07/07/2022

Arizona AADM Conference, 2022

06/29/2022

LS-DYNA Updates & Advancements in Ansys 2022 R1 - Webinar

06/23/2022

Simulation Best Practices for Wind Turbine Design - Webinar

06/15/2022

MAPDL Updates & Advancements in Ansys 2022 R1 - Webinar

06/01/2022

Mechanical Updates in Ansys 2022 R1 - pt. 2 Webinar

05/26/2022

Modelling liquid cryogenic rocket engines in Flownex - Webinar

05/25/2022

SMR & Advanced Reactor 2022

05/25/2022

05/24/2022

SMR & Advanced Reactor 2022

05/19/2022

RAPID + tct 2022

05/19/2022

Venture Cafe Roundtable: AI & Healthcare

05/18/2022

Tucson after5 Tech Mixer: World View

05/18/2022

RAPID + tct 2022

More Info

05/18/2022

Signal & Power Integrity Updates in Ansys 2022 R1 - Webinar

05/18/2022

Simulation World 2022

05/17/2022

RAPID + tct 2022

05/11/2022

Experience Stratasys Manufacturing Virtual Event

05/04/2022

Mechanical Meshing Updates in Ansys 2022 R1 - Webinar

04/27/2022

04/22/2022

12TH ANNUAL TUCSON GOLF TOURNAMENT

04/21/2022

04/20/2022

Additional Fluids Updates in Ansys 2022 R1

04/20/2022

Experience Stratasys Tour – Tempe Arizona

04/18/2022

Experience Stratasys Tour - Flagstaff Arizona

04/14/2022

D&M West | MD&M West

04/13/2022

D&M West | MD&M West

04/13/2022

Experience Stratasys Tour - Albuquerque New Mexico

04/12/2022

D&M West | MD&M West

04/12/2022

Experience Stratasys Tour - Los Alamos New Mexico

04/12/2022

Optimizing Engineering Workflows f​​​​or Propulsion System Design

04/07/2022

Experience Stratasys Tour - Austin Texas

04/07/2022

37th Space Symposium - Arizona Space Industry

04/06/2022

Transforming Digital Engineering with Ansys Discovery 2022 R1

04/06/2022

37th Space Symposium - Arizona Space Industry

04/05/2022

37th Space Symposium - Arizona Space Industry

04/04/2022

37th Space Symposium - Arizona Space Industry

03/30/2022

Simulation Best Practices for Vehicle Engineering - Webinar

03/23/2022

03/23/2022

High & Low Frequency Electromagnetics Updates in Ansys 2022 R1

02/24/2022

Arizona Technology Council After 5 Tech Mixer "Pandemic Pivot Pizza Pa

02/23/2022

SciTech Festival: Spend an Hour with 3D Printing Experts

02/11/2022

Webinar: Mechanical overview for Ansys 2022 R1

More Info

02/09/2022

Webinar: Product Development 101 (FAKE)

02/08/2022

Webinar: Navigating the Additive Landscape

01/27/2022

Arizona Technology Council 1st Quarter VIP Tech Mixer

More Info

01/26/2022

Simulation Best Practices for Gas Turbine Design & Development - Webin

More Info

01/19/2022

Arizona Photonics Days

More Info

11/04/2021

ExperienceIT, New Mexico

More Info

11/03/2021

Additive Manufacturing & Structural Optimization in Ansys 2021 R2 - We

More Info

11/03/2021

Optics Valley Technical Series: The Future of Simulation in the Optics

More Info

11/02/2021

SBIR Liftoff AZTC Virtual Breakfast Series

More Info

10/10/2021

Stratasys Mobile Truck Stop - Tucson Arizona

More Info

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: