SOLVED
Home

Potential bug in Microsoft Planner's Task Order Hint functionality

%3CLINGO-SUB%20id%3D%22lingo-sub-1126476%22%20slang%3D%22en-US%22%3EPotential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1126476%22%20slang%3D%22en-US%22%3E%3CP%3ECross-posting%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FPlanner-Tasks-OrderHint-value-not-respecting-order-within-Bucket%2Ftd-p%2F445202%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FPlanner-Tasks-OrderHint-value-not-respecting-order-within-Bucket%2Ftd-p%2F445202%3C%2FA%3E%26nbsp%3Bas%20I'm%20not%20sure%20if%20this%20is%20a%20Microsoft%20Power%20Automate%20bug%20--%20or%20a%20Microsoft%20Planner%20bug.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20manually-by-hand%20Tasks%20in%20a%20certain%20order%20in%20a%20Bucket%20in%20Microsoft%20Planner%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20244px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166977iD2050FF388763ACF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%222020-01-14%2017_31_24-Clipboard%20-%20initial%20task%20layout.png%22%20title%3D%222020-01-14%2017_31_24-Clipboard%20-%20initial%20task%20layout.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EIf%20I%20do%20a%20List%20Tasks%20and%20grab%20the%20JSON%20body%20of%20the%20List%20Tasks%20output%20via%20a%20Compose%20flow%20block%20e.g.%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166978iDE4E034F7B11E256%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%222020-01-14%2017_41_04-Clipboard-getListTasks_body.png%22%20title%3D%222020-01-14%2017_41_04-Clipboard-getListTasks_body.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...the%20Tasks's%20Order%20Hints%20order%20the%20Tasks%20to%20match%20what%20I%20see%20in%20Microsoft%20Planner%20in%20that%20Bucket%20(as%20expected)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3ETitle%3C%2FTD%3E%3CTD%3EOrderHint%20-%20Initial%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest5%3C%2FTD%3E%3CTD%3E8586225556019748676PQ%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest4%3C%2FTD%3E%3CTD%3E8586225556030217433Pl%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest3%3C%2FTD%3E%3CTD%3E8586225556040992244P6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest2%3C%2FTD%3E%3CTD%3E8586225556087825095PU%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest1%3C%2FTD%3E%3CTD%3E8586225556103966463P%7D%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CBR%20%2F%3EFor%20reference%20sake%2C%20my%20concept%20of%20direction%20of%20sorting%20is%20taken%20from%20this%20docs.Microsoft.com%20how-to%20article%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplanner-order-hint-format%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplanner-order-hint-format%3Fview%3Dgraph-rest-1.0%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ESo%20if%20I%20was%20to%20manually-by-hand%20re-arrange%20those%20Tasks%20in%20that%20Bucket%20in%20Microsoft%20Planner%20--%20and%20then%20run%20the%20same%20Flow%20to%20get%20the%20raw%20data%20of%20those%20Tasks%2C%20when%20sorted%20that%20raw%20data%20by%20Order%20Hint%2C%20the%20Task%20Titles%20should%20be%20ordered%20in%20a%20way%20that%20matches%20the%20display%20in%20Microsoft%20Planner%2C%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENope%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Microsoft%20Planner%2C%20in%20that%20same%20Bucket%2C%20I%20took%20the%20same%20Tasks%20and%20manually-by-hand%20I%20rearranged%20them%20into%20this%20order%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20247px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166981i995EFED912AE2BCF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%222020-01-14%2017_34_24-Clipboard%20-%20after%20sorting%20by%20title.png%22%20title%3D%222020-01-14%2017_34_24-Clipboard%20-%20after%20sorting%20by%20title.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20now%20run%20the%20same%20Power%20Automate%20Flow%20and%20retrieve%20the%20raw%20Task%20data%2C%20every%20one%20of%20those%20Tasks's%20Order%20Hints%20has%20not%20changed%20AT%20ALL%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3ETitle%3C%2FTD%3E%3CTD%3EOrderHint%20-%20Initial%3C%2FTD%3E%3CTD%3EOrderHint%20-%20After%20Manual-By-Hand%20Rearranging%20Tasks%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest5%3C%2FTD%3E%3CTD%3E8586225556019748676PQ%3C%2FTD%3E%3CTD%3E8586225556019748676PQ%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest4%3C%2FTD%3E%3CTD%3E8586225556030217433Pl%3C%2FTD%3E%3CTD%3E8586225556030217433Pl%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest3%3C%2FTD%3E%3CTD%3E8586225556040992244P6%3C%2FTD%3E%3CTD%3E8586225556040992244P6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest2%3C%2FTD%3E%3CTD%3E8586225556087825095PU%3C%2FTD%3E%3CTD%3E8586225556087825095PU%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETest1%3C%2FTD%3E%3CTD%3E8586225556103966463P%7D%3C%2FTD%3E%3CTD%3E8586225556103966463P%7D%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%3F%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1126476%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBUG%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPlanner%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1126611%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1126611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394668%22%20target%3D%22_blank%22%3E%40philCryo%3C%2FA%3E%26nbsp%3BAre%20you%20using%20the%20orderhint%20field%20on%20the%20Task%20entity%3F%20If%20so%20that%20is%20not%20what%20is%20used%20to%20sort%20tasks%20in%20the%20board%20view%20when%20grouped%20by%20buckets.%20Instead%20you%20need%20to%20look%20at%20the%20orderhints%20on%20the%20BucketTaskBoardTaskFormatting%20entity%20for%20the%20task.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129088%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156133%22%20target%3D%22_blank%22%3E%40Anubhav%20Singh%20(OFFICE%20365)%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20writing%20back.%26nbsp%3B%20Here%20are%20the%20fields%20I%20get%20when%20I%20run%20the%20List%20Tasks%20feature%20in%20Power%20Automate.%26nbsp%3B%20I%20don't%20see%20anything%20like%20%22BucketTaskBoardTaskFormatting%22%20as%20an%20attribute%20in%20this%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-javascript%22%3E%3CCODE%3E%20%22%40odata.etag%22%3A%20%3CTHE%20odata%3D%22%22%20etag%3D%22%22%3E%2C%0A%20%20%20%20%22planId%22%3A%20%3CPLAN%3E%2C%0A%20%20%20%20%22bucketId%22%3A%20%3CBUCKET%3E%2C%0A%20%20%20%20%22title%22%3A%20%3CTASK%20human-readable%3D%22%22%20title%3D%22%22%3E%2C%0A%20%20%20%20%22orderHint%22%3A%20%228586404548461516552%22%2C%0A%20%20%20%20%22assigneePriority%22%3A%20%22%22%2C%0A%20%20%20%20%22percentComplete%22%3A%20100%2C%0A%20%20%20%20%22startDateTime%22%3A%20null%2C%0A%20%20%20%20%22createdDateTime%22%3A%20%222019-06-21T21%3A20%3A39.3259255Z%22%2C%0A%20%20%20%20%22dueDateTime%22%3A%20null%2C%0A%20%20%20%20%22hasDescription%22%3A%20false%2C%0A%20%20%20%20%22previewType%22%3A%20%22reference%22%2C%0A%20%20%20%20%22completedDateTime%22%3A%20%222019-06-26T01%3A13%3A03.5170485Z%22%2C%0A%20%20%20%20%22referenceCount%22%3A%201%2C%0A%20%20%20%20%22checklistItemCount%22%3A%200%2C%0A%20%20%20%20%22activeChecklistItemCount%22%3A%200%2C%0A%20%20%20%20%22conversationThreadId%22%3A%20null%2C%0A%20%20%20%20%22id%22%3A%20%3CTASK%20unique%3D%22%22%20id%3D%22%22%3E%2C%0A%20%20%20%20%22createdBy%22%3A%20%7B%0A%20%20%20%20%20%20%22user%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%22displayName%22%3A%20null%2C%0A%20%20%20%20%20%20%20%20%22id%22%3A%20%3CUSER%3E%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%2C%0A%20%20%20%20%22completedBy%22%3A%20%7B%0A%20%20%20%20%20%20%22user%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%22displayName%22%3A%20null%2C%0A%20%20%20%20%20%20%20%20%22id%22%3A%20%3CUSER%3E%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%2C%0A%20%20%20%20%22appliedCategories%22%3A%20%7B%7D%2C%0A%20%20%20%20%22assignments%22%3A%20%7B%7D%2C%0A%20%20%20%20%22_assignments%22%3A%20%5B%5D%3C%2FUSER%3E%3C%2FUSER%3E%3C%2FTASK%3E%3C%2FTASK%3E%3C%2FBUCKET%3E%3C%2FPLAN%3E%3C%2FTHE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129202%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394668%22%20target%3D%22_blank%22%3E%40philCryo%3C%2FA%3E%26nbsp%3BThis%20is%20the%20Task%20entity%20only.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3EThe%20formatting%20entities%20are%20related%20entities%20for%20a%20task%3A%20For%20reference%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplannertask%3Fview%3Dgraph-rest-beta%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplannertask%3Fview%3Dgraph-rest-beta%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplannerbuckettaskboardtaskformat%3Fview%3Dgraph-rest-beta%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fplannerbuckettaskboardtaskformat%3Fview%3Dgraph-rest-beta%3C%2FA%3E%26nbsp%3Bfor%20a%20description%20of%20the%20BucketTaskboardTaskFormatting%20entity%20for%20a%20given%20task.%3CBR%20%2F%3E%3CBR%20%2F%3ENote%3A%20I%20am%20not%20familiar%20with%20Power%20automate%2C%20but%20given%20your%20json%20payload%20below%2C%20it%20is%20using%20the%20graph%20api%20under%20the%20hoods.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129412%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129412%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156133%22%20target%3D%22_blank%22%3E%40Anubhav%20Singh%20(OFFICE%20365)%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20ya%20look%20at%20that...It%20would%20appear%20that%20the%20Planner%20connector%20for%20Microsoft%20Power%20Automate%20does%20not%20have%20a%20way%20to%20retrieve%20the%20%22BucketTaskBoardTaskFormat%22%20of%20a%20Planner%20Task%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fplanner%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fplanner%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...even%20though%20the%20underlying%20Microsoft%20Graph%20API%20supports%20it%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129454%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394668%22%20target%3D%22_blank%22%3E%40philCryo%3C%2FA%3E%26nbsp%3BIndeed%2C%20unfortunately%20it%20does%20seem%20so.%20I'll%20see%20if%20I%20can%20get%20in%20touch%20with%20the%20Flow%20connector's%20owner%20and%20help%20them%20exposing%20more%20details.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1129496%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1129496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156133%22%20target%3D%22_blank%22%3E%40Anubhav%20Singh%20(OFFICE%20365)%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOh%20that%20would%20be%20awesome!%26nbsp%3B%20If%20it%20helps%20at%20all%2C%20here%20is%20my%20official%20feature%20request%20in%20the%20Power%20Automate%20forums%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FConnecting-To-Data%2FFeature-request-Access-Microsoft-Planner-Task-s%2Fm-p%2F453155%23M7558%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FConnecting-To-Data%2FFeature-request-Access-Microsoft-Planner-Task-s%2Fm-p%2F453155%23M7558%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(if%20there's%20a%20better%20place%20to%20put%20it%2C%20please%20let%20me%20know!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133298%22%20slang%3D%22en-US%22%3ERe%3A%20Potential%20bug%20in%20Microsoft%20Planner's%20Task%20Order%20Hint%20functionality%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133298%22%20slang%3D%22en-US%22%3EAnd%20I%20was%20requested%20to%20post%20to%20the%20Power%20Automate%20Ideas%20forum%3A%3CBR%20%2F%3E%3CBR%20%2F%3EAll%2C%20please%20vote%20for%20this%20feature-add%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPower-Automate-Ideas%2FAccess-Microsoft-Planner-Task-s-BucketTaskBoardTaskFormat-object%2Fidi-p%2F455274%23M19579%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPower-Automate-Ideas%2FAccess-Microsoft-Planner-Task-s-BucketTaskBoardTaskFormat-object%2Fidi-p%2F455274%23M19579%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Cross-posting from https://powerusers.microsoft.com/t5/Building-Flows/Planner-Tasks-OrderHint-value-not-respecting-orde... as I'm not sure if this is a Microsoft Power Automate bug -- or a Microsoft Planner bug.

 

Hi there,

 

I have created manually-by-hand Tasks in a certain order in a Bucket in Microsoft Planner:

 

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

 

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

 

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

 

...the Tasks's Order Hints order the Tasks to match what I see in Microsoft Planner in that Bucket (as expected):

 

TitleOrderHint - Initial
Test58586225556019748676PQ
Test48586225556030217433Pl
Test38586225556040992244P6
Test28586225556087825095PU
Test18586225556103966463P}


For reference sake, my concept of direction of sorting is taken from 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


So if I was to manually-by-hand re-arrange those Tasks in that Bucket in Microsoft Planner -- and then run the same Flow to get the raw data of those Tasks, when sorted that raw data by Order Hint, the Task Titles should be ordered in a way that matches the display in Microsoft Planner, right?

 

Nope :(

 

In Microsoft Planner, in that same Bucket, I took the same Tasks and manually-by-hand I rearranged them into this order:

 

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

 

When I now run the same Power Automate Flow and retrieve the raw Task data, every one of those Tasks's Order Hints has not changed AT ALL:

 

TitleOrderHint - InitialOrderHint - After Manual-By-Hand Rearranging Tasks
Test58586225556019748676PQ8586225556019748676PQ
Test48586225556030217433Pl8586225556030217433Pl
Test38586225556040992244P68586225556040992244P6
Test28586225556087825095PU8586225556087825095PU
Test18586225556103966463P}8586225556103966463P}

 

 

 

Help????

7 Replies
Highlighted
Solution

@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.

Highlighted

@Anubhav Singh (OFFICE 365) 

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": []

 

 

Highlighted

@philCryo 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-res... 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.

Highlighted

Hi @Anubhav Singh (OFFICE 365) 

 

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 :(

Highlighted

@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.

Highlighted

@Anubhav Singh (OFFICE 365) 

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...

 

(if there's a better place to put it, please let me know!)

 

Thank you again!

Highlighted
And I was requested to post to the Power Automate Ideas forum:

All, please vote for this feature-add: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Access-Microsoft-Planner-Task-s-BucketTaskB...