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

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,446)