Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on 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
    syed_sme 76 on at
    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
    jinivthakkar 4,177 on at
    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
    ChrisMendoza 425 on at
    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
    jinivthakkar 4,177 on at
    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
    syed_sme 76 on at
    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
    jinivthakkar 4,177 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard