How to export Version History, Comments, and Appended Comments to Excel from SharePoint List?

Question

How to export Version History, Comments, and Appended Comments to Excel from SharePoint List? I am using List to handle task requests. I want to capture all the back and forth between the request submitter and the person handling the request.

Answer 1

Hi @Chung, Stephen,

You can use "send an HTTP request to SharePoint" action in Power Automate to export list items with comments to Excel.

Reference: How to export list items with comments into excel/csv file using power automate? Export Sharepoint list items with comments into CSV file

By the way, you can use REST API call to get List Item’s Version History via this endpoint:

_api/web/Lists/getbyid(‘ListId’)/items(ItemId)/versions

You can integrate it with the above Power Automate flow.

Also, to export List Item’s Version History to Excel, you can use the PowerShell scripts in this article: SharePoint Online: Export List Version History to Excel using PowerShell

---

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.