cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,087)