Apps

Contains metadata for third-party and internal apps integrated into Microsoft Teams, including installation details, permissions, and usage metrics.

Table Specific Information

Select

This includes apps from the Microsoft Teams store, as well as apps from your organization's app catalog (the tenant app catalog). To get apps from your organization's app catalog only, specify Organization as the distributionMethod. The cmdlet 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 cmdlet.

displayName, Id, externalId support the '=', '!=', IN, LIKE, IS, IS NOT operator.

For example, the following queries are processed server side:

SELECT * FROM Apps WHERE DisplayName = 'MailChimp'

SELECT * FROM Apps WHERE DisplayName IN ('OneNote', 'Teams')

SELECT * FROM Apps WHERE Id LIKE '%-3b58-%'

SELECT * FROM Apps WHERE externalId IN (123, 156)

Delete

You can only remove the app from your organization's app catalog (the tenant app catalog). To remove an app record you need to specify the Id in WHERE clause.

DELETE FROM Apps WHERE Id = 'ffdb7239-3b58-46ba-b108-7f90a6d8799b'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	A unique identifier automatically assigned to the app when it is added to the Teams app catalog.
displayName	String	False	The human-readable name of the app as defined by the app developer for display in Microsoft Teams.
distributionMethod	String	False	Specifies how the app is made available to users, such as via store listing, side-loading, or organization-wide deployment.
externalId	String	False	The custom identifier defined by the app developer within the Teams app package, used for linking or internal tracking.

Cmdlets for Microsoft Teams

Apps

Table Specific Information

Select

Delete

Columns