cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BillPricePMP
Helper I
Helper I

orderby not working in HTTP Get in Power Automate?

I am unable to get the orderby function to work when I make an HTTP GET request of Planner.  $select seems to work but $orderby doesn't seem to.  Picture below shows me trying to test it in Graph Explorer but result appears to be same in the code.  I was unable to change the order of the responses (first 4 included) no matter what I chose to orderby.  I also was not able to get $top to work.  Permissions issue?  Feature not yet available?

 

I know there are other ways to do this but I was curious if anyone else was able to get this to work?  I'm trying to migrate towards API and bulk actions so instead of using the GUI to get the tasks then filter by bucket then order them I was trying to perform it all in one API step.

 

HTTP orderby.jpg

3 REPLIES 3
abm
Super User
Super User

Hi @BillPricePMP 

 

Try adding orderBy=orderHint to your query

 

office365 - Planner "orderHint" attribute does not work - Stack Overflow

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
BillPricePMP
Helper I
Helper I

Thank you for your suggestion however it does not appear to support title.

Hi @BillPricePMP 

 

Looks like this feature is not available yet. You could push the details into an Excel script or use a custom connector to do the sorting.

 

Please have a look at Paul's video

 

(1076) How to easily sort arrays in Power Automate - YouTube

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (1,504)