cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Advocate II
Advocate II

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

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!

Top Solution Authors
Top Kudoed Authors
Users online (7,864)