Export part of a Sharepoint List

Question

We have a large Sharepoint List with several views. Is there a way to export only part of a Sharepoint List or export a View that is filtered?&nbsp;

derhallim · Answer

You'll need to create a view for it if you want to export it. Otherwise, you'll need to do something with Power Automate, pass it the filter you need, and it'd create your file in your OD4B, but out of the box in SharePoint you have only the export to excel button which only works on the current view.

derhallim · Answer

Where do you want to export this to? Excel? To another list?

tbruns · Answer

derhallim&nbsp;Yes to Excel&nbsp;

derhallim · Answer

If you switch to a specific view and click on "Export to excel" in the command bar (just beside quick edit), it will only export that view (columns and items) to excel (actually it's a query file, but you can easily save it to excel since it opens in Excel by default).

Note it will give you 2 extra columns, but that's easy to get rid of.

tbruns · Answer

derhallim&nbsp;I am needing to export a specific view that is filtered. Example: I am only wanting to export anything with a day of 6/1/2020. Is that possible?

Forum Discussion

Export part of a Sharepoint List

Share

Resources