'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Collect Comments from All SharePoint Site Pages
Question details
Administrators need a way to consolidate and record all comments from across various SharePoint site pages, including authors and page locations.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Tracking user feedback and mentions across an entire SharePoint site to ensure no comments are missed.
- Observed behavior
- SharePoint lacks a built-in feature to view a consolidated log of all comments across multiple site pages, requiring manual checking.
Ensure you have the necessary administrative permissions for the SharePoint site and have the PnP PowerShell module installed on your system.
Use PnP PowerShell and SharePoint REST API
Create a PowerShell script to iterate through the Site Pages library and fetch comments using the REST API.
Since SharePoint does not offer a native centralized comment dashboard, administrators can leverage PnP PowerShell. By enumerating the Site Pages library, you can programmatically call the Comments endpoint for each page ID.
Connect to your SharePoint site using the Connect-PnPOnline command in PowerShell.
Enumerate all items in the 'Site Pages' library to get their specific page IDs.
Iterate through each page and call the REST API endpoint: /_api/web/lists/GetByTitle('Site Pages')/GetItemById(pageId)/Comments.
Extract the comment authors, text, and metadata from the JSON response and export the consolidated data to a CSV file or trigger a notification.
Looking for a Lightweight Document Collaboration Solution?
While managing complex SharePoint scripts can be daunting, everyday document collaboration shouldn't be. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy seamless formatting, familiar interfaces, and robust built-in commenting tools without the heavy overhead.
- 1. Download WPS Office: Visit the official WPS website to download and install WPS Office Free on your device.
- 2. Open Your Documents: Easily open your existing Microsoft Office files without worrying about formatting issues.
- 3. Collaborate and Comment: Use the Review tab to easily add, reply to, and manage comments directly within your documents.
Frequently Asked Questions
Is there a built-in web part to view all SharePoint comments at once?
No, SharePoint currently does not offer an out-of-the-box web part or consolidated dashboard to view all comments across multiple site pages.
What permissions are needed to query comments via the SharePoint REST API?
You need at least Read access to the Site Pages library to retrieve the pages and their associated comments using the REST API.
Where can I get help writing the PnP PowerShell script for SharePoint?
The Microsoft Q&A forum is the official and recommended platform for detailed scripting assistance and troubleshooting related to SharePoint REST API.
