TeamsInstalledApps
Tracks which apps are installed in each Microsoft Team, detailing installation context such as user, group, or channel level.
Table Specific Information
Select
Query the TeamsInstalledApps table by retrieving everything from teams or by specifying TeamId with = and IN operators. By default only the installed apps for teams of the groups you are a member of will be returned. To retreive installed apps for teams of all groups in your organization, set IncludeAllGroups property to true. The provider 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 provider.
- TeamId supports the '=' and IN operators.
- AppId supports the '=' operator.
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 AppId = '14d6962d-6eeb-4f48-8890-de55454bb136'
Insert
TeamId and AppId are required to insert a new app in a team.
INSERT INTO TeamsInstalledApps (TeamId, AppId) Values ('4729c5e5-f923-4435-8a41-44423d42ea79', '0fd925a0-357f-4d25-8456-b3022aaa41a9')
Delete
To delete an installed app record you need to specify the Id and TeamId in 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. |