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

Reverse Order of Table Data in Flow

Hi all.,

 

i have list of Task (Upto 15 row) from SQL Table and the same Task need to create in Planner as a Planner Task.

planner.PNG

i had created a flow, its successfully created all Task but its create as a first created Task as a Last in buckets. but i need the Task in reverse order.

 

i need to sort the Task order as below:

 

planner1.PNG

can anyone help me to resolve this..

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @Talha,

 

How would you like the task to be displayed in the output of "Get List of task" action?

Do you have a field that could be ordered to achieve your requirement?

 

Please take a try with Sytnax "asc or desc keyword "for the order by field in the "Get List of task" action

You could refer to link below for a referance :

https://powerusers.microsoft.com/t5/Building-Flows/Sytnax-for-Odata-Order-By/td-p/55185

 

Best regards,

Alice

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @Talha,

 

How would you like the task to be displayed in the output of "Get List of task" action?

Do you have a field that could be ordered to achieve your requirement?

 

Please take a try with Sytnax "asc or desc keyword "for the order by field in the "Get List of task" action

You could refer to link below for a referance :

https://powerusers.microsoft.com/t5/Building-Flows/Sytnax-for-Odata-Order-By/td-p/55185

 

Best regards,

Alice

View solution in original post

Thanks for your reply.

i used Desc as ID like

 

sort.PNG

 

i got results 

thanks again

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,474)