Excel Add-In for Microsoft Teams

Build 25.0.9434

TeamMembers

Retrieves the list of users who are members of a specific Microsoft Teams team.

Table Specific Information

Select

The add-in will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.

  • TeamId supports the '=,IN' operators.

For example, the following query is processed server side: 

SELECT * FROM TeamMembers WHERE TeamId = 'f7985bee-7fb4-404d-a954-5ba68ae7c8db'

SELECT * FROM TeamMembers WHERE TeamId IN ('f7985bee-7fb4-404d-a954-5ba68ae7c8db', 'da838338-4e77-4c05-82a6-79d9f0274511')

Columns

Name Type Description
Id [KEY] String Unique identifier for the team member in Microsoft Teams.
TeamId String Identifier of the team to which the member belongs.
DisplayName String Full display name of the team member.
email String Email address of the team member.
Roles String Roles assigned to the team member, such as owner or member.
TenantId String Identifier of the Microsoft 365 tenant associated with the team member.
UserId String Unique user identifier for the team member.
StartDateTime Datetime Timestamp indicating when the membership history for the team started.

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