How to use 'order by' / 'get items'

(0) Share

Report

Posted on by Mana

171

Hello all,

I have a SP list called Employeelist. This list has a column called' EmployeeName' which has a value 'Mr XXX'. What I'am struggling with is to sort this list by column ' EmployeeName' but always show the specific value 'Mr XXX' at the end of the list.

I would be so happy if it can be done inside of Order BY in get items but I'm not sure if its possible.

Is there a way to do that?

Any help will be appriciated.

Thank you in advance.

Cheers Angela

@v-dezhili-msft

Categories:

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I Believe you can do the following, just replace the column name:

if you want it sorted another way do desc instead of asc.

Was this reply helpful? Yes No
Mana 171 on at

Like (0)

Report
Copy link

Link copied!

yes but I want to have the specific value to be at the end of the list

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Assuming you mean the sort order within your SharePoint List itself and not within Power Automate - one way would be to add a Calculated Column and set the formula to:

//Assuming your field display name is Employee Name =IF([Employee Name]="Mr XXX","ZZZZ",[Employee Name])

Then in your main view, set the Order by your Order field.

An example of what the List would look like:

If that's not what you meant, then let us know.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No