Skip to main content

Notifications

Community site session details

Community site session details

Session Id : OdM7qswcrYiNNPf0HRrd8S
Power Automate - General Discussion
Answered

Post reply to a Teams channel when a sharepoint list item is updated

Like (0) ShareShare
ReportReport
Posted on 23 Feb 2021 12:55:34 by 76
Hi all,
 
I am posting a message to a Teams chat Channel when a Sharepoint item is created.
 
I would like to post a reply to that message when the sharepoint item is modified but I can't seem to figure out how to reference the original messgeID in my reply?
 
Any help would be much appreciated.
 
Regards,
Syed
  • syed_sme Profile Picture
    76 on 25 Feb 2021 at 10:00:29
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    Thanks both @ChrisMendoza  and @jinivthakkar .

     

    This was really helpful and much appreciated.

  • jinivthakkar Profile Picture
    4,177 on 23 Feb 2021 at 19:41:16
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    @ChrisMendoza I too thought so but I tried of doing it in one flow.

     

    @syed_sme As Chris has already tried this why don't you create two flows and lets close the topic here.

     

    The solution I gave I didn't realize it would go in Infinite loop.

     

     

  • Verified answer
    ChrisMendoza Profile Picture
    425 on 23 Feb 2021 at 19:14:03
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    Try 2 separate flows. I have experienced issues with When an item is created or modified trigger.

    1. When an item is created
    2. When an item or a file is modified

     

  • jinivthakkar Profile Picture
    4,177 on 23 Feb 2021 at 19:06:09
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    @syed_sme I will update you on this tomorrow, I acknowledge this is an issue.

  • syed_sme Profile Picture
    76 on 23 Feb 2021 at 17:53:01
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    Thanks @jinivthakkar,

     

    I managed to replicate the flow as you instructed above and it works to a point.

     

    The thread is created and in the channel as expected but the Update Item action is triggering the reply immediately afterwards. So, I moved the Update outside of the Condition branch but this made not difference.

     

    I'm also seeing the following warning message....

    syed_sme_0-1614102494582.png

     

    Any ideas how to get round this?

     

    Thanks in advance.

     

    Syed

  • jinivthakkar Profile Picture
    4,177 on 23 Feb 2021 at 14:13:53
    Re: Post reply to a Teams channel when a sharepoint list item is updated

    @syed_sme please follow below steps:

     

    Add column in SharePoint list, MessageID which will be used to store message ID of the teams message

    jinivthakkar_0-1614089248975.png

    Flow is as follows:

     

    In the condition I am checking the value of MessageID from list column

    jinivthakkar_1-1614089377445.png

     

    My Yes block, I update the item with the message id from post a message as this a new item and I store the message id so it can be used to reply to the original message when item is modified.

    jinivthakkar_2-1614089483369.png

     

    My No block, I pass the message ID from the item as it is existing item and it is being modified.

    jinivthakkar_3-1614089536979.png

    Output

    jinivthakkar_4-1614089595529.png

     

    Hope this helps.

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started