cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
StarlaTreece
Level: Power Up

Outlook tasks to planner with categories

I organize my to-do lists using task within Outlook.  I love the look and feel of planner and would like to sync my outlook tasks with planner and be able to carry over my categories.   I found the create planner tasks from new Outlook Tasks, but I can't figure out how to carry over my categories.   I want my categories to be "buckets" in planner and if the bucket doesn't exisist yet, it would be created. 

 

I think once I figure this out, it would fairly easy to figure out the other syncing flows (deleting tasks in planner does the same in Outlook and visa versa....etc).   Anyone have any advance on how to the categories to translate to buckets?

1 REPLY 1
DionGoile
Level: Powered On

Re: Outlook tasks to planner with categories

If you do List All Tasks you get the following output, these are what you are able to work with from within Flow

 

  {
    "@odata.id": "https://outlook.office.com/api/v2.0/Users')",
    "@odata.etag": "\"",
    "Id": "AAMkADA5",
    "CreatedDateTime": "2017-05-17T04:01:56.5238918Z",
    "LastModifiedDateTime": "2017-05-17T04:01:37.543Z",
    "ChangeKey": "ClNAAWII=",
    "Categories": [
      "Blue Category"
    ],
    "AssignedTo": "",
    "HasAttachments": false,
    "Importance": "Normal",
    "IsReminderOn": false,
    "Owner": "Dion Goile",
    "ParentFolderId": "AQMkADA5MTlkOTEyLmQ3MWIxYzAALgAAA-6N_HRd2aRInAAAA==",
    "Sensitivity": "Normal",
    "Status": "NotStarted",
    "Subject": "Test",
    "Body": {
      "ContentType": "HTML",
      "Content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"Generator\" content=\"Microsoft Exchange Server\">\r\n<!-- converted from rtf -->\r\n<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>\r\n</head>\r\n<body>\r\n<font face=\"Calibri\" size=\"2\"><span style=\"font-size:11pt;\">\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>\r\n</span></font>\r\n</body>\r\n</html>\r\n"
    },
    "CompletedDateTime": null,
    "DueDateTime": {
      "DateTime": "2017-05-18T14:00:00",
      "TimeZone": "UTC"
    },
    "Recurrence": null,
    "ReminderDateTime": null,
    "StartDateTime": {
      "DateTime": "2017-05-18T14:00:00",
      "TimeZone": "UTC"
    }
  }

You can then use the Data Operations - Parse JSON function to get this information and export it to variables you can use.

 

Use the above JSON (or the export from List as Tasks in Flow History) to generate the object using sample payload, then you will be able to use categories as per the below picture.

 

Capture.PNG

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 51 members 4,675 guests
Please welcome our newest community members: