Forum Discussion
Autoamate the sharepoint export button without using power automate
Hi,
Is there any way I can automate the export to excel button without using power autonate? I found this button is so powerful, it clean the data for us, so I would like to automate by using this button. Using power automate will have problem with values, some of the columns it won't get the dynmic value.
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.
- GaryLin30Copper Contributor
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.
- Robert_van_den_BrinkCopper ContributorIk have basically the same question. I want to export the "Active sites" to excel/csv but not manually. Is there a way to automate this process so that this list is sent to an Emailaddress once a month?