Hello,
How to get a comments from a sharepoint list in an email with Power Automate?
I don t see a value in Power Automate for this!
Are the other trick instant of do it in a column?
Kind regards,
Sander
Thanks you so much! The idea is always easy and looks easy to do ;). But when you are doing it. Its always a little bit complex in Power Automate 🙂 Thanks
Hi @Anonymous,
You can use the following URI to only retrieve 1 comment. Microsoft is automatically sorting it descending, so this will be the last comment.
Share
Report
All responses (
Answers (
_api/web/lists/getbytitle('@{variables('ListName')}')/items(@{variables('ListItemId')})/Comments?$top=1
If you want to avoid using a parse json and an apply to each action you can also use an expression to retrieve the correct fields of the comment item.
Below is an example of retrieving the text of a comment of the first (and only) item in a compose action by using an index [0] and the text field.
outputs('Send_an_HTTP_request_to_SharePoint')?['body']['d']['results'][0]['text']
Thanks its works. But then wanne get the last comment. If i do that after a parse Json, He is going into an apply to each get if me every comment and a lots of emails :). How to avoid that? So that i get the last comment of the item ?
Hi @Anonymous,
You can retrieve the comments by using a Send an HTTP request to SharePoint action.
Below is an example which retrieves the comments for one specific list item.
_api/web/lists/getbytitle('@{variables('ListName')}')/items(@{variables('ListItemId')})/Comments
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
