how to sort excel table

[bren88]

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?

[rsaikrishna]

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

[rsaikrishna]

@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

[bren88]

@rsaikrishna 

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

[rsaikrishna]

@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

[bren88]

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

[rsaikrishna · Accepted solution]

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

Regards

Krishna Rachakonda