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

Like (0) Share

Report

Posted on 23 Feb 2021 12:55:34 by syed_sme

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

All responses (6)

Answers (1)

syed_sme 76 on 25 Feb 2021 at 10:00:29

Like (0)

Report

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 4,177 on 23 Feb 2021 at 19:41:16

Like (0)

Report

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 425 on 23 Feb 2021 at 19:14:03

Like (1)

Report
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.
When an item is created
When an item or a file is modified
jinivthakkar 4,177 on 23 Feb 2021 at 19:06:09

Like (0)

Report

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 76 on 23 Feb 2021 at 17:53:01

Like (0)

Report

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

Any ideas how to get round this?

Thanks in advance.

Syed
jinivthakkar 4,177 on 23 Feb 2021 at 14:13:53

Like (0)

Report

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
Flow is as follows:

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

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.

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

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.