Print from SP List on SPO

Question

Hello, how to print SPList or SPList view on SPO?

Ctr+P and export to csv/xlsx are not appropriateMoved from: Microsoft 365 and Office | SharePoint | Development

Answer 1

Disclaimer: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Dear @Hadzhiyska, Eleonora,

Good day. Thank you for posting your question in the Microsoft Q&A forum!

First of all, I would like to apologize for any inconvenience this may have caused.

I understand how important it is to have a simple and user‑friendly way to print a SharePoint list or list view, especially when options such as Ctrl + P or Export to CSV/Excel do not meet your needs. I apologize for the inconvenience this limitation may cause.

At this time, if you are a user, there is unfortunately no built‑in or direct print button available in SharePoint Online lists or list views. Given this limitation, I would recommend submitting feedback to Microsoft so the product team can better understand this business need and consider it for future improvements. Your feedback plays an important role in shaping upcoming features. I sincerely recommend you go to Feedback community to vote this similar feedback: (find out similar feedback, if not provide the feedback forum link Ideas · Community). Our product team is in charge of the site, and they constantly check customer reviews and feedback. The higher votes, the more attention the related team will pay on. And a lot of the features are developed and improved based on customer feedback. 

That said, I would also like to share that some other users have reported success using workarounds, and you may wish to test whether these approaches work for your scenario:

• Generate PDF files from SharePoint List items using Power Automate By creating a Power Automate flow, list items can be converted into a PDF format that is more suitable for printing. You can refer to this detailed guide for reference: https://steveknutson.blog/2022/01/25/create-a-pdf-from-a-sharepoint-list-item-with-power-automate/
• Add a custom button to trigger the Power Automate flow Using JSON column formatting, it is possible to add a button within the list that allows users to trigger the flow directly. Additional examples can be found here: https://republicofdevelopers.com/add-custom-action-buttons-to-sharepoint-list-items-using-column-formatting/

While these solutions are not native print features, they have been effective for other users in similar scenarios and may serve as a practical alternative.

Thank you for your understanding and for taking the time to share your feedback. Please feel free to reply below if you have any update or further concern.  

Hope you have a great day!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

To print a SharePoint List (SPList) or a view from SharePoint Online (SPO), you can use PowerShell to facilitate this process. While the Ctrl+P shortcut and exporting to CSV/XLSX are common methods, they may not meet your needs as you mentioned.

Using PowerShell, you can retrieve the data from the SharePoint List and send it directly to the printer. Here’s a basic example of how you might accomplish this:

# Connect to SharePoint Online
Connect-PnPOnline -Url "https://yourtenant.sharepoint.com" -UseWebLogin

# Get the list items
$listItems = Get-PnPListItem -List "YourListName"

# Format the output and send to printer
$listItems | Format-Table | Out-Printer

This script connects to your SharePoint Online site, retrieves the items from the specified list, formats them into a table, and sends the output to the default printer. Make sure to replace YourListName with the actual name of your SharePoint List.

This method allows you to bypass the limitations of the browser's print functionality and gives you more control over the output format.

---

References:

• Why you need to use PowerShell for Microsoft 365