Integrate comment in the SP list to export to Excel

Copper Contributor

Hello, I need to know how to display the comments in the new "comments on SP list" feature in the SP list to be able to export them to Excel. Thank you.

4 Replies
Hi,
Community Lounge only revolves around topics about tech community website itself, for product support, please find a suitable and related community hub and post your topic there, you can find them by clicking/tapping on "Community Hubs" at the top of every page in this website.

https://techcommunity.microsoft.com/t5/communities/ct-p/communities
Currently there is not a way to see the comments apart from the comments panel and to export them

@Juan Carlos González Martín  @Daniela Dalbokova There is no out of the box way to do this, however, comments for each item can be retrieved via the REST API. You could build a custom process if you really need to export them.

https://beaucameron.net/2020/12/16/retrieve-modern-sharepoint-list-item-comments-using-rest/


As mentioned by others, there is still no way to export the comments OOTB. However, I have created a power automate for same while working on similar requirement. Please check it out and let me know if it helps.

https://divyeshkotadia.wordpress.com/2023/04/21/how-to-export-list-items-with-comments-into-excel-cs...