Aug 09 2022 01:51 PM - edited Aug 09 2022 04:29 PM
How do I make it easy for someone to print a SharePoint list that is filtered and make it come out clean and formatted? The people who would be printing this are Presidents so I dont want them to fumble through exporting to Excel as they are not familiar with this environment especially when it comes to printing. I know it will come out out of page range.
Aug 09 2022 08:58 PM - edited Aug 09 2022 09:20 PM
There is no OOTB way to do so, you can add your custom button in List View using SPFX Extension - List View Command set and you can implement your own logic for print.
Below is the similar thread which is doing print for single item with template so you can extend it according to your requirement to support printing of all the list items.
https://github.com/pnp/sp-dev-fx-extensions/tree/main/samples/react-command-print
Hope it will helpful to you
Aug 10 2022 02:39 AM
Aug 10 2022 02:44 AM - edited Aug 10 2022 02:45 AM
As mentioned in previous reply, sample which I shared is only for single item, you need to adapt it for entire list.
and it's not the JSON code but it's SharePoint Framework Application Customizer - List View Command set which is using React as Framework so if you are starting your journey then first you need to grab some knowledge about SharePoint Framework
Documentation
https://docs.microsoft.com/en-us/sharepoint/dev/spfx/sharepoint-framework-overview
Hope it will help to you.
Aug 10 2022 02:51 AM
Aug 10 2022 02:54 AM
Aug 10 2022 03:03 AM
@VeeExcelLearn like you I do not have access to SPFx. If your list doesn't have too many columns you can use a flow in Power Automate to save it to an HTML table and then a PDF. But that might be too fiddly for something that should be simple out of the box.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Aug 10 2022 03:06 AM
Aug 10 2022 03:08 AM
@VeeExcelLearn if you have a lot of columns you won't be able to clean it up sufficiently for it to look good in the HTML table and PDF.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)