Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

You must be an admin on Microsoft Teams to approve the integration; anyone can install and use the Smartsheet for Teams app. 

FAQ: Integrate Smartsheet with Microsoft Teams

PLANS

  • Pro
  • Business
  • Enterprise

Permissions

You must be an admin on Microsoft Teams to approve the integration; anyone can install and use the Smartsheet for Teams app. 

What is supported in the Smartsheet for Teams integration?

  • Send notifications from Smartsheet to a public Teams channel or as direct messages. 
  • Add Smartsheet items as tabs within channels in Teams.

What permissions are required for the Smartsheet for Microsoft Teams Integration app?

Your Microsoft Teams admin needs to grant consent to the Smartsheet app before it becomes available to members in your organization. The following table contains the permissions required by the Smartsheet app.

Capability

Permission name and type

Reason for requesting this permission

Receive Smartsheet notifications in Teams channels

offline_access - delegated

Enables refresh token in authentication response and maintains login when the token expires

openid - delegated

Allows Smartsheet to sign into Microsoft on behalf of the user

profile - delegated

Gives information about the user to send notification

Team.ReadBasic.All - delegated

Used to get the Team names 

Channel.ReadBasic.All - delegated

Used to get channels in a Team using a team ID

User.Read - delegated

Used to get information about the user's organization

TeamsAppInstallation.ReadWriteForTeam - delegated

Allows Smartsheet to check if the Teams app is installed. If not, the app is installed automatically.

Sharing Smartsheet assets with channel members when adding it as Tab in teams

ChannelMember.Read.All - Application

Used to get channel members for any channel using group id and channel id

ChatMember.Read - Delegated

Used to get members in a private channel

Also, the messaging extensions don't require any additional setup. When a user adds the Smartsheet for Microsoft Teams app from the Teams app store, the messaging extension is automatically usable and no additional permissions are required. See how to use the messaging extension to search Smartsheet items from Microsoft Teams.

Can I still add a Smartsheet item as a tab without Admin permission?

If your admin has not granted permission, users can still add Smartsheet items as tabs by either publishing them or not sharing the item to channel members.

What is supported in the Smartsheet EU for Teams integration?

Send notifications from Smartsheet EU to a public Teams channel.

If I already use the Tabs capability in the Smartsheet EU for Microsoft Teams integration, then why am I not receiving Smartsheet notifications in Microsoft Teams?

When using the Smartsheet EU for Teams integration, grant access to add Smartsheet EU items as tabs. To get Smartsheet EU notifications in Microsoft Teams, re-grant admin consent.

 

Was this article helpful?
YesNo