Microsoft Teams and Smartsheet

Microsoft Teams

Triggers

• New channel messageRuns for each new post in a Teams channel, with its text and who wrote it. Replies in a post's thread don't start it, and nor do posts already there when the workflow is turned on. How often it checks follows your workspace plan.
• New chat messageRuns for each new message in a Teams chat, with its text and who wrote it. Messages already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• New reply in channelRuns for each new reply in the threads of a Teams channel, with its text, who wrote it and the post it answers. Replies already there when the workflow is turned on don't start it. How often it checks follows your workspace plan. Untested on Microsoft's government clouds.
• New channelRuns when a channel is added to a Teams team, with its name, description and link. Channels already there when the workflow is turned on don't start it, and private channels you aren't in aren't seen. How often it checks follows your workspace plan. Untested on Microsoft's government clouds.
• New team memberRuns when someone is added to a Teams team, with their name and email. Members already there when the workflow is turned on don't start it. Watches teams of up to 4,000 members. How often it checks follows your workspace plan. Untested on Microsoft's government clouds.

Actions

• Send chat messageSend a message to a Teams chat.
• Send channel messageSend a message to a Teams channel.
• Create channelCreate a new channel in a Teams team.
• Add member to teamAdd a member to a Teams team.
• List user chatsList chats for a user.
• Schedule meetingSchedule a Teams meeting.

Smartsheet

Triggers

• New rowRuns when a row is added to a Smartsheet sheet.
• Row changedRuns when a row in a Smartsheet sheet is changed, once for each change.
• New commentRuns for each new comment on a Smartsheet sheet or one of its rows, with who wrote it and the row it's on. Comments already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• New attachmentRuns for each new file or link attached to a Smartsheet sheet, one of its rows or a comment. Attachments already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.

Actions

• Get my accountGet the Smartsheet account this connection uses: name, email address, time zone and organization.
• List workspacesList the workspaces you can open, with your access to each.
• SearchSearch everything you can open in Smartsheet (sheets, rows, reports, comments and attachments) for some words. Smartsheet may take a few minutes to find something just added.
• List sheetsList the sheets you can open, alphabetically, optionally only those changed since a date and time.
• Get sheetGet a sheet with its columns and rows, each row's cells by column name. Large sheets come a page at a time.
• Create sheetCreate a sheet in a workspace or one of its folders, with the columns you name. Add typed columns (dates, dropdowns) with 'Add column'.