cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jennyntc
New Member

How to used order by in sharepoint?

Hello, I am leaning how to used power automate.

 

If I want to sort data ordinal scale in get items (sharepoint) how can I do?

I want to sort by risk level (high, medium, low)

 

Thank you 

4 REPLIES 4
Gopala_Krishna
Super User
Super User

@Jennyntc 

For sorting the data in the GetItems action of SharePoint you have to specify the column name followed by the sortorder type.

 

Example : I want to sort column called ID in descending order then I can specify the Odata query as "ID desc

 

Columnname sortordertype (Ex: asc for ascending, desc for descending)

 

 

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

Thank you 

I try to 'Risklevel desc'

But it cannot sort by High,medium,low 

 

Gopala_Krishna
Super User
Super User

@Jennyntc 

Did you get any error when you passed the query?

What type of column is Risklevel

Did not get any error but it order by

1.medium

2.low

3.high

I want to orderby 1.high 2.medium 3.low

My type of column is 'text'

 

Thank you 🥰

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.

Users online (2,907)