cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cadone
Helper V
Helper V

Email when some one writes a comment to SharePoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

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:

3.1-11.PNG

 

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.

View solution in original post

6 REPLIES 6
DamoBird365
Microsoft
Microsoft

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
Microsoft
Microsoft

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:

3.1-11.PNG

 

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.

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

@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.  

@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
Microsoft
Microsoft

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.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,897)