Unanswered

Get notify when a comment is created

(0) Share

Report

Posted on by CU19091143-0

I need a solution to do basically one of the options below.

Notify when a comment is added to a list item

Or

check every "x" time if a comment was added to a list item

IF Yes

Send a email

As far as I know there is no trigger for comments
I could not retrieve the "Comment" status using the "Get changes for an item or a file (properties only)"

I don't know if is possible to automatically copy the last comment to a hide column using JSON or column settings, so that will trigger the "When an item is modify" but I am open to new ideas.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@CU19091143-0 Hi,

You can try to use that polling for new comments using a scheduled flow, for example every 30 min.

Use 'Send_an_HTTP_request_to_SharePoint' to get the comment only

get: _api/web/lists/getbytitle('YourList')/items(ID)/Comments

for your reference:

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU19091143-0,

As far as I know, there isn't a trigger that can tell us when a new comment has been added to a SharePoint list item.

@stampcoin This won't work, because you are polling only one list item using its ID (there could be 100s or 1000s of items!). It needs to run at the list level.

How to retrieve SharePoint List item comments using Power Automate

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Ellis Karim thanks for your friendly comment, I don't think I need to write everything here.

I just share my idea to give some lead, not everything.

thanks again for sharing the article.😉

Was this reply helpful? Yes No
CU19091143-0 4 on at

Like (0)

Report

Thank you @stampcoin and @Ellis Karim

I think the issue here is that I don’t want to retrieve the actual comment—I don’t need its content. I just want to send a notification when a new comment is added.

The problem is, I can’t figure out the logic to differentiate between a comment that was posted yesterday and one that was posted 5 minutes ago.

Using “Get changes for an item or a file (properties only)”, you can check whether a column was modified (returns true or false), but I don’t see how to apply that to comments specifically.

Can I get that with a HTTP Request? or any ideas on how to solve this. This is basically a Ticket system.

Screenshot 2025-0...

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@CU19091143-0 Hi,
your idea is on the right track.

I don't think you will get comment from “Get changes for an item or a file (properties only)” , the extra filed has to use 'Send an HTTP request to sharepoint', my ideas is create separated column , for example 'Latest_comment_date_time', and compare the createdDate, maybe combine modifiedDate if you need.

below is an example part of the output , query against Comment.

"body": { "value": [ { "author": { "directoryObjectId": null, "email": "", "expiration": null, "id": 7, "isActive": true, "isExternal": false, "jobTitle": null, "loginName": "i:", "name": "", "principalType": 1, "userId": null, "userPrincipalName": null }, "createdDate": "2025-01-27T09:38:36.74Z", "id": "301", "isLikedByUser": false, "isReply": false, "itemId": 301, "likeCount": 0, "listId": "6exxxxxx-xxxx-xxx-ax5b-axxxxxxxy", "mentions": [ { "email": "", "id": , "loginName": "", "name": "" }, // and more.... ], "modifiedDate": null, "parentId": "0", "replyCount": 0, "text": "@mention{0} @mention{1} reply content....." }//,and more ] }

basically, it would be like below:

Scheduled flow (run every 5–15 mins)

Get list items where Latest_comment_date_time is blank or older than now

Call the Graph API to get comments for each item

Compare comment timestamps with your Latest_comment_date_time

If new comments found:

Send notification

Update the Latest_comment_date_time column

Please try it yourself first, if you stuck somewhere, post the question, you will get help from community.

Was this reply helpful? Yes No