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

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 )

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,412)