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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,975)