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
rsaikrishna
Community Champion
Community Champion

@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?

rsaikrishna
Community Champion
Community Champion

@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 ?

rsaikrishna
Community Champion
Community Champion

@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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,676)