Forum Discussion
dalbokova
Jan 13, 2021Copper Contributor
Integrate comment in the SP list to export to Excel
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.
- Divyesh KotadiaCopper ContributorAs 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-csv-file-using-power-automate/ - Currently there is not a way to see the comments apart from the comments panel and to export them
jcgonzalezmartin 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/
- 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