Comments from List - send email

[Anonymous]

When a new comment is left on a list item I'd like to trigger an email.  Unfortunately, I don't see a good way to reference what field was updated.  Any advice would be greatly appreciated.

[Brad_Groux]

The Trigger would be When an item is created or modified, and triggers when a specific SharePoint List is updated. The full Flow would look something like this:

The Get item is optional, but gives you a bit more control with the parameters available to you. Then, the condition runs, and when the Comment column is not equal to null (meaning the comment column has been updated with text),send the email.

Reference Links:

• Add a condition to a flow
• Apply to Each
• Use expressions in conditions to check multiple values
• A Visual Explanation of Flow Logical Expressions

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Thanks  @Brad_Groux.  I was thinking that, but wouldnt that mean if the item is updated again later and already has a comment that it would trigger again?

[Brad_Groux · Accepted solution]

Yes, but you could also add another condition to stop it from running again. A few examples:

• When a comment is made for the first time, and the email flow is sent, update a hidden column titled Email Sent? and switch the toggle from No to Yes. Then, build a condition within the Flow, if Email Sent? is equal to Yes, then don't send the email. 
• Filter out the Yes responses in the hidden Email Sent? column in the When an item is created or modified trigger in a different view.
• Create a time-based condition referencing the created or modified dates. If the Modified date column is Less than or equal to today (Utcnow), then don't send the email.
• Or if you know they must submit a comment when the item is created, change the trigger to When an item is created 
• Etc. 

The possibilities with conditions based on logical expressions are nearly endless. You just have to think outside the box to figure out which works best for your environment and your dataset(s). 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Excellent, thanks @Brad_Groux !