Forum Discussion
Potential bug in Microsoft Planner's Task Order Hint functionality
philCryo Are you using the orderhint field on the Task entity? If so that is not what is used to sort tasks in the board view when grouped by buckets. Instead you need to look at the orderhints on the BucketTaskBoardTaskFormatting entity for the task.
Thank you for writing back. Here are the fields I get when I run the List Tasks feature in Power Automate. I don't see anything like "BucketTaskBoardTaskFormatting" as an attribute in this list.
"@odata.etag": <the odata etag>,
"planId": <plan's unique id>,
"bucketId": <bucket's unique id>,
"title": <task human-readable title>,
"orderHint": "8586404548461516552",
"assigneePriority": "",
"percentComplete": 100,
"startDateTime": null,
"createdDateTime": "2019-06-21T21:20:39.3259255Z",
"dueDateTime": null,
"hasDescription": false,
"previewType": "reference",
"completedDateTime": "2019-06-26T01:13:03.5170485Z",
"referenceCount": 1,
"checklistItemCount": 0,
"activeChecklistItemCount": 0,
"conversationThreadId": null,
"id": <task unique ID>,
"createdBy": {
"user": {
"displayName": null,
"id": <user's id>
}
},
"completedBy": {
"user": {
"displayName": null,
"id": <user's id>
}
},
"appliedCategories": {},
"assignments": {},
"_assignments": []
MicrosoftphilCryo This is the Task entity only.
The formatting entities are related entities for a task: For reference: https://docs.microsoft.com/en-us/graph/api/resources/plannertask?view=graph-rest-beta
Also https://docs.microsoft.com/en-us/graph/api/resources/plannerbuckettaskboardtaskformat?view=graph-rest-beta for a description of the BucketTaskboardTaskFormatting entity for a given task.
Note: I am not familiar with Power automate, but given your json payload below, it is using the graph api under the hoods.
Would ya look at that...It would appear that the Planner connector for Microsoft Power Automate does not have a way to retrieve the "BucketTaskBoardTaskFormat" of a Planner Task:
https://docs.microsoft.com/en-us/connectors/planner/
...even though the underlying Microsoft Graph API supports it 😞
- Anubhav Singh (OFFICE 365)
philCryo Indeed, unfortunately it does seem so. I'll see if I can get in touch with the Flow connector's owner and help them exposing more details.
Oh that would be awesome! If it helps at all, here is my official feature request in the Power Automate forums: https://powerusers.microsoft.com/t5/Connecting-To-Data/Feature-request-Access-Microsoft-Planner-Task-s/m-p/453155#M7558
(if there's a better place to put it, please let me know!)
Thank you again!