Forum Discussion
Autoamate the sharepoint export button without using power automate
GaryLin30 What do you mean by "automating the export to excel button" in SharePoint lists?
Are you trying to customize the functionality for any specific requirements? Unfortunately, there is no way to customize the functionality of this out of the box button in SharePoint lists. You can only rename orc show/hide it using JSON formatting, nothing else.
If you want completely customized export to excel button on SharePoint lists, you can develop it using SPFx ListView command set extension.
Here's one SPFx sample for same which might help you to get started with: SPFx Export Selected Items to Excel - ListView Command Set
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi ganeshsanap,
Thanks for the response.
The meaning of "automating the export to excel button" is that I would like to use the function of the export button to export our sharepoint list itmes into csv file for power bi.
I have tried use power automate to add table and add rows, which is not best practice cause the export button function is good to go already.
I aslo tried power bi read from online sharepoint list which didn't work for unknow reason(internal server error). Some sources said the reason might be the list is over 5000 rows. (We have 6K itmes in list)
GaryLin30 If you are using modern experience custom SharePoint list, you can export it as CSV using this option:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.