cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philCryo
Advocate I
Advocate I

Planner Tasks OrderHint value not respecting order within Bucket

Hi there,

 

I have my Planner Tasks in a certain order in a Bucket:

2020-01-14 17_31_24-Clipboard - initial task layout.png

If I do a List Tasks action and grab the JSON body of the List Tasks output via a Compose flow block:

2020-01-14 17_41_04-Clipboard-getListTasks_body.png

 

 

...when sorting those Tasks by the Planner Order Hint values, as expected, the Tasks end up ordered in a way that matches what I see in Microsoft Planner:

 

TitleOrderHint - Initial
Test58586225556019748676PQ
Test48586225556030217433Pl
Test38586225556040992244P6
Test28586225556087825095PU
Test18586225556103966463P}

 

However, if I now manually-by-hand arrange those same Planner Tasks in the same Planner Bucket -- say ordered by Task Title ascending:

2020-01-14 17_34_24-Clipboard - after sorting by title.png

...and then use the same List Tasks -> Compose (ListTasks.output.body) flow, the OrderHint values for those same Tasks "Test1" through "Test 5" DO NOT CHANGE even though the Tasks themselves have been re-ordered in Planner. According to this docs.Microsoft.com how-to article: https://docs.microsoft.com/en-us/graph/api/resources/planner-order-hint-format?view=graph-rest-1.0 -- the Order Hints should have changed so that when sorted that raw JSON Task data by Order Hint ascending, the Tasks would then match what I see in Planner.

 

HELP????

1 ACCEPTED SOLUTION

Accepted Solutions

Here's what I found via my cross-post to the Microsoft Tech Community's Planner board:

 

A Microsoft Planner Task's OrderHint is just for sorting if all of a Planner's Tasks were clumped together into a simple list.  It is not for sorting to make a list like when looking at Microsoft Planner's Web UI.

 

Within Power Automate, if I wanted to sort a list of Planner Tasks that are within a single Planner Bucket in the order shown in the Microsoft Planner's Web UI, I would need to have the ability to retrieve each Planner Task's "BucketTaskBoardTaskFormat": https://docs.microsoft.com/en-us/graph/api/resources/plannerbuckettaskboardtaskformat?view=graph-res...

 

MS Graph offers the ability to get that "BucketTaskBoardTaskFormat" object....but unless I'm mistaken, Power Automate doesn't appear to have an accessor method that will retrieve that object: https://docs.microsoft.com/en-us/connectors/planner/

 

UGH!!!!!!!!!

 

(thanks to Anubhav Singh for figuring out what was missing!!! https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/156133 )

View solution in original post

6 REPLIES 6

@philCryo 

Hi there.  So, the orderhint property looks like fun.  What I suspect is happening is that the orderhints are really only changed if you manually affect the sort (creating a custom sort).  If you sort using name or some other canned property, the planner UI is probably ignoring the orderhint and using that property instead.

 

I did find an article that you may find useful, along with the official documentation.

 

Either way, keep us posted.  I'm curious to see if my theory is correct.

 

Thanks,

-Ed-

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

@edgonzalesI manually re-arranged the Tasks within the Bucket in the Planner -- just like in the the official documentation to which you linked -- which describes "placing" an item before another item which would then "create" order hints.

 

But that's not happening here.  Manual re-arrangement of Tasks within the Bucket did not change the order hints.

 

HELP???

Anybody?  Is this a bug in either Power Automate's retrieval of Planner tasks -- or a bug in Planner itself?

BUMP

 

FYI I edited the original post to hopefully clarify a few things.  I've also cross-posted this to the Microsoft Planner Tech Community as well: https://techcommunity.microsoft.com/t5/planner/potential-bug-in-microsoft-planner-s-task-order-hint/...

Here's what I found via my cross-post to the Microsoft Tech Community's Planner board:

 

A Microsoft Planner Task's OrderHint is just for sorting if all of a Planner's Tasks were clumped together into a simple list.  It is not for sorting to make a list like when looking at Microsoft Planner's Web UI.

 

Within Power Automate, if I wanted to sort a list of Planner Tasks that are within a single Planner Bucket in the order shown in the Microsoft Planner's Web UI, I would need to have the ability to retrieve each Planner Task's "BucketTaskBoardTaskFormat": https://docs.microsoft.com/en-us/graph/api/resources/plannerbuckettaskboardtaskformat?view=graph-res...

 

MS Graph offers the ability to get that "BucketTaskBoardTaskFormat" object....but unless I'm mistaken, Power Automate doesn't appear to have an accessor method that will retrieve that object: https://docs.microsoft.com/en-us/connectors/planner/

 

UGH!!!!!!!!!

 

(thanks to Anubhav Singh for figuring out what was missing!!! https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/156133 )

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,290)