Email when some one writes a comment to SharePoint list

[cadone]

Hello Guys

Is it possible to get an e-mail alert when some one comments on the SharePoint list?

I am thinking, we can use a modify item trigger. Or perhaps some kind of condition that will trigger only when the “comment” section is modified. Not sure if this conditional trigger is possible. 

Next, I want to get that item. Now, parse the “comments” section to a compose or a variable action. Then email the data to desired email. 

Do you guys think this is doable this way?

Thanks 

C1

[DamoBird365]

Hi @cadone,

I might be wrong but I have tested this myself tonight and it doesn't look like adding comments constitute a modification to the item, therefore the flow will not trigger when you add a comment.  Comments are not returned in the output of the trigger either.  The only suggestion would be encourrage users to leave comments in a multi line column that you call "comments" specifically for your flow/purpose.  At the moment it's not even possible to disable comments from an individual list, albeit you can do this at a global level.  I would expect in time for Microsoft so support more granular controls at site level.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[v-yiwenxie-msft · Accepted solution]

Hi @cadone 

Do you mean you want the flow to send an email with details of an item whose ‘Comments’ column has been changed?

If yes, then the following flow is for your reference:

If I’ve misunderstood your need, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DamoBird365]

Hi @v-yiwenxie-msft ,

That's interesting and i've learnt something there, but how/can you trigger on comments being made?  From what I could tell, you can only trigger on column changes of which comments were not one of them.  Or has my testing not worked? 🙂

Cheers,

Damien

[cadone]

@DamoBird365 

That’s right. I noticed it too. Commenting won’t be considered as item modification. Which makes sense. Also Commenting is not even has its column either. So I considered to create y own column.  

[cadone]

@v-yiwenxie-msft 

I like your I idea. Kudos. 
Just to clean up the comments and keep consistency, I considered formatting the comments in the flow. Added the lines

##### comments start #####

##### comments end #####

also, wanted to add the commenter name/time to know who wrote. I used user profile to get that data and appended. 

unfortunately, the flow caught itself in an infinite loop. This is because the trigger reads the formatting as a modified item. 

so I just considered not to format. Simply email certain key people to notify the new comments entry.

[v-yiwenxie-msft]

Hi @cadone 

Can I assume that your problem has been solved? If yes, could you please mark it as the solution to help other members find it more quickly?

If no, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.