Forum Discussion
Display Comments in Sharepoint list
Hello, we can now use the new sharepoint comment function to comment a list item. Is there a possibilty to show the last comment in the table view? Or get this via JSON formatter? I only ha...
Currently it is not possible to get the comments using JSON formatting. You can only get the count of comments added to list item using [$_CommentCount].
Comments are stored in list schema itself and not with list item. Check below blog for more information:
SharePoint Online: All you need to know about Commenting in Lists
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap I followed your link to add the Comment Count to JSON and it worked very well. Thank you for providing a usable alternate solution.
ganeshsanap Hello! Thank you for the helpful information. I was also wondering if it is possible for comments to be included in a Power Automate flow? Currently I have flows built for list items to move from one list to another based on a Column selection ('Status') and would like for comments to also migrate when the list items moves to the other list based on the flow. Is this possible?
List comments are not supported by default using SharePoint connector in Power Automate. You can manage that using SharePoint REST APIs.
Check "Working with SharePoint REST APIs" section in below blog for REST API endpoint to work with list comments:
SharePoint Online: All you need to know about Commenting in Lists
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
