Excel Add-In for Microsoft Teams

Build 25.0.9434

ChatMessageMentions

Get Chat Message Mentions.

Table Specific Information

Select

The add-in uses the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:

  • ChatId supports '=' operator.

The rest of the filter is executed client side within the add-in.

The following is an example query:

SELECT * FROM ChatMessageMentions WHERE ChatId = '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_e4ea490e-b30c-4b1e-92b0-337117920315@unq.gbl.spaces'

Columns

Name Type Description
Id String The Chat Messages Id.
ChatId String The Chat Id.
Mentions_Id Int The Id of the mention.
MentionText String The MentionText of the mention.
User_Id String The User_Id of the mention.
User_DisplayName String The User_DisplayName of the mention.
User_TenantId String The User_TenantId of the mention.
Application_Id String The Application_Id of the mention.
Application_DisplayName String The Application_DisplayName of the mention.
Application_TenantId String The Application_TenantId of the mention.
Device_Id String The Device_Id of the mention.
Device_DisplayName String The Device_DisplayName of the mention.
Device_TenantId String The Device_TenantId of the mention.
Conversation_Id String The Conversation_Id of the mention.
Conversation_DisplayName String The Conversation_DisplayName of the mention.
Conversation_ConversationIdentityType String The Conversation_ConversationIdentityType of the mention.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434