Returns replies to a specific message in a Microsoft Teams channel thread.

View-Specific Information

SELECT

The add-in uses the Microsoft Teams API to process WHERE clause conditions built with the columns and operators shown below. The add-in executes the rest of the filter client-side.

The ChannelMessageReplies view supports only a subset of columns for filtering. Below is a table containing those columns with their supported operations.

Column	Supported Operators
TeamId	=
ChannelId	=
MessageId	=
Id	=

Note: No inputs are required. When no WHERE clause conditions are specified, the add-in automatically retrieves TeamId, ChannelId, and MessageId by traversing Teams, Channels, and ChannelMessages respectively.

Example Queries

The add-in executes this by traversing Teams, Channels, and ChannelMessages from the Microsoft Teams API:

SELECT * FROM ChannelMessageReplies

This query retrieves all replies for a specific message:

SELECT * FROM ChannelMessageReplies WHERE TeamId = '4729c5e5-f923-4435-8a41-44423d42ea79' AND ChannelId = '19:[email protected]' AND MessageId = '1688061957561'

Columns

Name	Type	Description
Id [KEY]	String	Unique identifier for the reply message in Microsoft Teams.
MessageId	String	Identifier of the parent channel message whose replies are being retrieved.
BodyContent	String	Plaintext or rich text content of the reply body.
BodyContentType	String	Specifies the format of the reply body content, such as text or HTML.
ChannelId	String	Identifier of the Microsoft Teams channel where the parent message was posted.
TeamId	String	Identifier of the team associated with the channel.
Mentions	String	List of entities mentioned in the reply. Supported entities include user, bot, team, and channel.
Reactions	String	List of reactions applied to the reply, such as like or heart.
Attachments	String	References to objects attached to the reply, such as files, tabs, or meetings.
Importance	String	Priority level of the reply, such as normal, high, or urgent.
CreatedDateTime	Datetime	Timestamp indicating when the reply was created.
LastEditedDateTime	Datetime	Timestamp indicating when the reply was last edited.
LastModifiedDateTime	Datetime	Timestamp indicating when the reply was last updated.
DeletedDateTime	Datetime	Timestamp indicating when the reply was deleted, or null if it has not been deleted.
MessageType	String	Type of message, such as standard or system notification.
ChatId	String	Identifier of the chat thread when the reply is part of a threaded conversation.
Etag	String	Version identifier for the reply used for concurrency control.
FromUserDisplayName	String	Display name of the user who sent the reply.
FromUserId	String	Unique identifier of the user who sent the reply.
FromUserUserIdentityType	String	Specifies the identity type of the user who sent the reply.
FromApplication	String	Name of the application that sent the reply, if applicable.
FromDevice	String	Name of the device used to send the reply, if available.
Locale	String	Locale setting of the reply as defined by the client application, typically en-us.
PolicyViolation	String	Details about any policy violations associated with the reply.
ReplyToId	String	Identifier of the parent channel message. Always equal to MessageId for rows in this view.
Subject	String	Subject line of the reply in plaintext, if provided.
Summary	String	Summary text of the reply for use in notifications or fallback views.
WebUrl	String	Direct link to view the reply in Microsoft Teams.
EventDetail	String	Details about the event associated with the reply, if applicable.