web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power automate : notif...
Power Automate
Unanswered

Power automate : notification on new comment in sharepoint list

(0) ShareShare
ReportReport
Posted on by 5

Hello,

 

At our company, we share a SharePoint list with our mother company in Japan. I already added several flows related to this list which work just fine. However, I can't seem to figure out how to create a power automated notification whenever a new comment is added into the comments section of the item? Is there a relatively easy way to do this? (in some old

 

Many thanks for your support in advance,

Bart

Categories:
I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @Bart_VdB 

     

    Trigger based on change in the comments in not supported in SharePoint connector. But there are couple of workarounds, mentioned in one of the previous posts:

    Solved: Flow to and email when Sharepoint list item commen... - Power Platform Community (microsoft.com)

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • Bart_VdB Profile Picture
    5 on at

    Dear @ManishSolanki ,

     

    Thanks for your prompt feedback. I was already afraid that this hasn't been implemented so far. I voted for the change. Hopefully, they will add this feature at some point.

     

    Cheers,

    Bart

     

     

  • vgreyes Profile Picture
    14 on at

    Hello @Bart_VdB  - 

     

    Since we aren't able to create a flow trigger off a new SharePoint list comment, I created a Teams notification that is triggered off the email that is sent automatically when a comment is added to SharePoint list. 

     

    vgreyes_0-1693528943019.png

     

    The messages from Microsoft use a standard template for the Subject when a new comment is added to a SharePoint list item, so I used that to create a Subject Filter. Replace the LIST NAME with your unique List Name.

     

    vgreyes_1-1693529018112.png

    Initialize a string variable and then set it to the body of the email message:

    vgreyes_2-1693529075464.png

     

    Use the next two Compose functions to 1) trim all the beginner information away from the start of the URL and 2) then split the remaining string into multiple strings and only return the first item of the resulting strings.

     

    vgreyes_3-1693529148784.png

     

    COMPOSE TrimStart:

    substring(variables('Text'),IndexOf(variables('Text'),'https://YOURDOMAIN.sharepoint.com/sites/SITENAME/Lists/LISTNAME'))

     

    COMPOSE Split TrimStart:

    first(split(outputs('Compose_TrimStart'),'" shash="'))

     

    Finally, format the Teams message to include the resulting URL as a usable link in the Teams notification: 

     

    vgreyes_4-1693529260051.png

     

    Hope this helps!

    Vanessa

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard