Auto Reply to MS Teams chat Once

(0) Share

Report

Posted on by send2mark

505

I am looking for a way to auto reply to only the first message in MS Teams. It sounds like I need a SharePoint list or Excel file to track the incoming message with a condition but I cannot seem to work through this. I am hoping someone else has done this and can help me develop it.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report
You can achieve this with below steps

Go to SharePoint and create a new list. Name it "TeamsMessageTracker". Add these columns:

Title: This will store the user’s display name.

User ID: This will store the user’s unique Teams ID.

Replied: This will be a Yes/No checkbox to track if a reply has been sent.

Open Power Automate and create a new flow.

Select the trigger "When a new message is posted in a channel" if you want to track channel messages. If you want to track personal chats, use the trigger "When a new message is posted in a chat". Note that personal chat tracking requires a premium license.

After the trigger, add an action called "Get items" for SharePoint. Configure it to check your SharePoint list (TeamsMessageTracker) and filter by the User ID of the person who sent the message. This will check if the user already exists in the list.

Add a condition. If the user does not exist in the list, continue with the next steps. If the user exists, stop the flow.

If the user does not exist in the list, add an action to send an auto-reply. Use the action "Post a message in a chat or channel". Write your reply, for example: "Thank you for your message! I'll get back to you shortly."

Add another action to create a new item in the SharePoint list. Save the user’s display name in the Title column, their unique Teams ID in the User ID column, and set Replied to Yes.

End the flow after these steps.

This way, the flow will only reply to the first message from a user, and it will track users in the SharePoint list to avoid replying multiple times. If you prefer not to use SharePoint, you can do the same with an Excel file instead.

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report

User name does not seem to be an option for dynamic content. I am currently trying to get the "Message Conversation ID" to work, but it doesn't seem to be working.

Was this reply helpful? Yes No