Dec 08 2020 06:00 AM
Dec 08 2020 06:00 AM
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 have found a solution to get the number of comments:
Where are these comments stored? Is there a possibility to embed them on a sharepoint modern page?
Dec 08 2020 07:36 AM
Dec 16 2020 02:02 PM
@chhe112 I had the same issue and watched network requests while adding a comment to a list item. There's a usuable API! I reproduced like this:
https://<tenant>.sharepoint.com/<site>/_api/web/lists(@a1)/GetItemById(@a2)/Comments()?@a1='<list guid>'&@a2='<comment ID>'
Now I just need to figure out how to trigger a Flow when new comments are made Open to ideas!
Jan 10 2021 12:49 AM
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:
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.
Feb 09 2021 10:58 AM
@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?
Feb 09 2021 11:58 PM
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:
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.