Forum Discussion
SPNoob2021
May 14, 2021Copper Contributor
Sharepoint List and Exporting Specific Selected Items to CSV file
Hi is there any way to export only the selected items in a sharepoint list to a CSV file. I see if you don't select any items you export the whole list to a csv file for my application and customers I want to be able to select list items and export only the selected list items to a csv file. Thanks, Sharepoint Noob.
No export available after selecting items from the list.
12 Replies
Sort By
- shriG625Copper ContributorHello, did you get any solution for this? I am in the same requirement. I want to export to CSV file only selected items.
- RobElliottSilver Contributor
shriG625 you can export individual items via a JSON-formatted button on the list which triggers a flow in Power Automate to add that row into your spreadsheet.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- Marc_RotheraCopper ContributorRobElliott, is it possible to have something like this that creates a new excel (named with info from the row) for each export? (I'd like to create a new excel doc for each line in my sharepoint list).
I've looked around but I can't find any further reference to how to create the solution you've described here, is it something you're able to share please?
- PkeschingerCopper ContributorI did just find out that if you change your list view to grid view you can click the radio button for 1 item and then click Ctrl+c and it will copy all of the data across the lists so you can paste it into a file, then click exit grid view to see the list view again.
- brownman311Copper ContributorSimple and easy workaround, thanks for sharing!
- PkeschingerCopper ContributorI am working on the same thing. At this point I have only been able to pull it with the full export.
- Joe_ChoiCopper ContributorAny news on this topic ?
- If you create a new View that shows just the items you want to export. You can do this by filtering the various columns you want and then choose 'Save View As' from the View dropdown list and give it a name.
- SPNoob2021Copper Contributor
So every time I need to export 5 of the list of 100 items I need to create a view?
SPNoob2021
- SPNoob2021Copper Contributor
THe sharepoint list I have has a radio button for the selection. It is the first field but unlabeled. Is there any way to check if that field is selected for the list elements and then only display those items selected in the view and then do an export of only the ones in the view? Filter on that column for that view? It's an unlabeled column.