How to used order by in sharepoint?

[Jennyntc]

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 

[Gopala_Krishna]

@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

[Jennyntc]

Thank you 

I try to 'Risklevel desc'

But it cannot sort by High,medium,low 

[Gopala_Krishna]

@Jennyntc 

Did you get any error when you passed the query?

What type of column is Risklevel

[Jennyntc]

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 🥰