cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bren88
Helper II
Helper II

how to sort excel table

I need to export a Sharepoint list into an Excel table but I want to sort the Excel table by the 'Category' column.

Do I use Order By in Get Items? What is the syntax to put in here?

1 ACCEPTED SOLUTION

Accepted Solutions

@bren88 

 

Browse SharePoint site you are using to export the SharePoint list to Excel.

Navigate to the SharePoint list. 

In the All Items view, if you see Category column, next to the column you will see a down icon. Click on it. It will give you options to Sort A to Z, Z to A. Select any option.

p4.JPG

 

Regards

Krishna Rachakonda

View solution in original post

6 REPLIES 6
rsaikrishna
Community Champion
Community Champion

@bren88 

 

In the Order By field, just mention the column name. If the column name has spaces, use Internal name of the column.

 

This orders the items in Ascending order.

 

Regards

Krishna Rachakonda

If this reply helps you, please mark the reply as Accepted Solution.

 

@bren88 

 

If my earlier post helped you resolving the issue, can you please mark it as Accepted Solution. When users reaches your post, they will know that my reply worked as a solution.

 

Regards

Krishna Rachakonda

@rsaikrishna 

It can't find the column name. How can I find out the internal name of this column?

@bren88 

 

There are multiple way to find the internal name of the SharePoint list column.

 

In the SharePoint list, if you sort the Category column, in the URL, you can see sortField=<internal name of the column>

 

Please let me know if you need any more help.

 

Regards

Krishna Rachakonda

Where do I do this, can you give more instructions please ?

@bren88 

 

Browse SharePoint site you are using to export the SharePoint list to Excel.

Navigate to the SharePoint list. 

In the All Items view, if you see Category column, next to the column you will see a down icon. Click on it. It will give you options to Sort A to Z, Z to A. Select any option.

p4.JPG

 

Regards

Krishna Rachakonda

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,079)