
Announcements
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?
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> </div>\r\n<div> </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.