Smartsheet and Microsoft Teams

Our company has used Slack. I was able to automate (through Zapier) the following: When a new row was added to a particular sheet in smartsheet, a new message was posted to a particular Slack Channel. We just switched from Slack to Microsoft Teams. Does anyone know of a way to create a similar automation? (Zapier doesn't seem to work well with Teams) (I.E. A new row on Smartsheet automatically posts a message to a Channel in Microsoft Teams)? Thanks.

Find more posts tagged with

Sheets

Integrations

Email Notifications

Comments

davelevinJWT

We just recently adopted Microsoft Teams too, and we use the Teams connecter. I'd be interested in an answer to the same question (e.g., notifications showing up in Teams instead of via email re: tasks that are due for a project).

Andrée Starå

Hi,

You can do this with the help of Microsoft Flow.

More info: https://flow.microsoft.com/sv-se/connectors/shared_teams/microsoft-teams/

https://flow.microsoft.com/sv-se/connectors/shared_smartsheet/smartsheet/

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

L Thrasher

Hi. It did not help. I am trying to set it up and when I run the test it submit an individual message to the channel for each comlumb I have. SO if I add one row to the smartsheet, it sends 15 different messages to teams channel for each of the 15 different columns on that one row. Id prefer to pick the columns I'd like to include and have it post just one message to the channel if possible. Any idea how to do that? Thanks.

Andrée Starå

If it's possible (don't remember if it is in Flow like it's in Zapier), you would need to add something to the Flow that identifies which column you want to notify, or maybe you would have to set up 15 different Flows.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

urmila.kukreja

Hi!

We released the capability to notify your Teams Channel when there are changes in your Smartsheet. You can set up these alerts under Alerts and Actions in your sheet. You can read more about it here: https://www.smartsheet.com/apps/microsoft-teams

I would love to hear your feedback on this integration. (urmila.kukreja@smartsheet.com)

Urmila Kukreja

Product Manager

urmila.kukreja@smartsheet.com

Sign in to join the conversation!

Quick Links

Trending discussions

Onedrive & DocuSign Integration Capabilities
I am in the process of designing our Smartsheets workflow and am trying to better understand the capabilities / limitations of these integrations. Current Process: 1) We receive a PDF (say an invoice). 2)Manually save the file in Onedrive updating the file name. 3) Manually enter the data from the PDF into a SS Form and…
Dynamic View - Loading Issues
Is anyone experiencing issues with Dynamic View showing a bunch of blank flashing rows when loading instead of the normal revolving circle that says loading? As a result, it shows the flashing rows for a bit and then nothing to display despite the fact it should be displaying certain data for users. We have shared groups…
DocuSign Status Column Not Updating Consistently (Non-Mapping Issue)
Hi Smartsheet Community, We’re hoping to tap into the collective expertise here about a DocuSign integration issue. Here’s our setup: •All information is collected via a Smartsheet form. •Based on certain cell values, one of several DocuSign integrations is triggered. •Documents are generated and routed correctly in…