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
Dual Super User
Dual Super User

@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

View solution in original post

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!

Users online (2,238)