TeamsInstalledApps
Tracks which apps are installed in each Microsoft Team, detailing installation context such as user, group, or channel level.
Table-Specific Information
SELECT
The component uses 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 component.
- TeamId supports the = and IN operators.
- TeamsAppId supports the = operator.
By default, only installed apps for teams in groups you are a member of are returned. To retrieve installed apps for teams of all groups in your organization, set IncludeAllGroups to true.
For example, the following query is processed server-side:
SELECT * FROM TeamsInstalledApps WHERE TeamId IN ('f7985bee-7fb4-404d-a954-5ba68ae7c8db', 'da838338-4e77-4c05-82a6-79d9f0274511') AND TeamsAppId = '14d6962d-6eeb-4f48-8890-de55454bb136'
INSERT
TeamId and TeamsAppId are required to install an app in a team.
INSERT INTO TeamsInstalledApps (TeamId, TeamsAppId) VALUES ('4729c5e5-f923-4435-8a41-44423d42ea79', '0fd925a0-357f-4d25-8456-b3022aaa41a9')
DELETE
To delete an installed app, specify the Id and TeamId in the WHERE clause.
DELETE FROM TeamsInstalledApps WHERE TeamId = 'f7985bee-7fb4-404d-a954-5ba68ae7c8db' AND Id = 'Zjc5ODViZWUtN2ZiNC00MDRkLWE5NTQtNWJhNjhhZTdjOGRiIyMyMGMzNDQwZC1jNjdlLTQ0MjAtOWY4MC0wZTUwYzM5NjkzZGY='
Columns
| Name | Type | ReadOnly | Description |
| TeamId | String | False |
The unique identifier of the Microsoft Team where the app is installed. |
| TeamsAppId | String | False |
The identifier of the Teams app instance installed in the Team. |
| TeamsAppDefinitionDescription | String | False |
A detailed description of the app as defined in the app's manifest or Teams App Catalog. |
| TeamsAppDefinitionDisplayName | String | False |
The name of the Teams app as shown to users in the Microsoft Teams client. |
| TeamsAppDefinitionLastModifiedDateTime | Datetime | False |
The timestamp indicating when the app definition was last updated in the Teams App Catalog. |
| TeamsAppDefinitionPublishingState | String | False |
The current publishing state of the app definition, such as submitted, published, or rejected. |
| TeamsAppDefinitionShortDescription | String | False |
A brief summary of the app's functionality or purpose, taken from the app manifest. |
| TeamsAppDefinitionVersion | String | False |
The version number of the app definition currently installed in the Team. |