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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,514)