Any function or method to get custom sort function will be use in microsoft graph api

Question

Custom sorting that can help to all the data in excel sheet will be a sorted data from the API level we can functionally in excel sheet that will be a same thing to apply in Microsoft Graph API so that will be a possible way to guide.

Answer 1

Hi @Abhay Maheta

If you are only looking to sort excel sheet table data using Graph API you can use TableSort resource type.
Use this POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/apply Graph API along with the body to apply sort on table.
Please refer to this documentation for more details.

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.