Connect to Microsoft Teams

Learn how to connect Microsoft Teams to Retool.

You can connect to Microsoft Teams and make it available as a resource in Retool. Once complete, your users can send messages, manage channels, and much more.

Requirements

All users for Retool organizations on Free or Team plans have global Edit permissions and can add, edit, and remove resources. If your organization manages user permissions for resources, you must be a member of a group with Edit all permissions.

To create a Microsoft Teams resource, you need:

  • your Microsoft Teams client ID (only required when you self-host Retool).
  • your Microsoft Teams client secret (only required when you self-host Retool).

1. Create a new resource

Sign in to your Retool organization and navigate to the Resources tab. Click Create new, then select Resource.

Create a new resource

2. Select the resource type

Retool can connect to almost any API or database, and has built-in integrations for popular data sources. Select the Microsoft Teams resource type.

Select the resource type

3. Configure the resource

Specify a name and location for the Microsoft Teams resource. Retool displays the resource name and type in query editors to help users identify them.

By default, Retool requests a limited set of common OAuth scopes when you connect your workspace. These scopes determine the operations you can perform. If you update the list of scopes in your resource settings, you must reconnect with OAuth for the changes to take effect.

Configure the resource

If you self-host Retool, complete the Self-hosted deployments section before moving to the next step. Otherwise, click the Connect with OAuth → button to authenticate with your Microsoft Teams account and continue to the next step.

Self-hosted deployments

🚧

This section is only necessary if you self-host Retool. Microsoft Teams is only available on self-hosted Retool v2.123 and later.

When you self-host Retool, you need to register your own Azure Active Directory application with Microsoft Graph.

After registering, go to the App registrations section of the Azure Active Directory menu in your Azure portal. Generate your client secret in the Certificates & secrets section of the app. Note it is saved in the Value field. Copy your client ID, found in the Overview section of your Microsoft app, and client secret into your resource settings.

Configure the resource

You also need to configure your Microsoft Teams app with the OAuth callback URL and scopes. Copy the OAuth callback URL on the Retool resource settings page. Then, in your Microsoft app settings, click into the Authentication section and add the OAuth callback URL to the Redirect URIs section.

After you've finished setting up your Microsoft app and resource, click the Connect with OAuth → button on the resource settings page to authenticate.

4. Save the resource

Click Create resource to complete the setup. You can then click either Create app to immediately start building a Retool app or Back to resources to return to the list of resources.

Wrap up

Your Microsoft Teams resource is now ready to use. To interact with Microsoft Teams, select the resource in the query editor. See Microsoft Graph's API documentation for more information about Teams related endpoints.