Forum Discussion
Is it possible to export the result of a search from a sharepoint list to excel
OOTB this is not possible. We have therefore extended the search bar functionality with sort and filters and also included an export to CSV option. https://www.slimapplications.com/wp-content/uploads/2022/10/explorerSearchSortFilter.png
The custom search bar uses search rest api and the exported CSV contains the name, full URL and modified date. Which fields do you need?
Who is going to use the functionality? end-users or administrators or ...
If only administrators need it then PowerShell is also a pragmatic option.
Paul_HK_de_Jong
Missed a bit of Context- is this a third party Plugin Search bar?
- Paul de JongDec 07, 2022Iron Contributor
No, it is not a third party plugin search bar. It is part of an app that mimics File Explorer in a browser (https://directory.collab365.com/listing/slim-companion-explorer/). The logic for the search bar (plus the sorting options and search filters, see https://www.slimapplications.com/wp-content/uploads/2022/10/explorerSearchSortFilter.png) can in principle be isolated and be included into a separate custom search bar App.
The search REST API is rich in functionality and performance is awesome. This allows for building apps that simplify use of SharePoint.