Microsoft Excel and Microsoft Outlook

Microsoft Excel

Triggers

• New row in an Excel tableRuns when a new row is added to a table in an Excel workbook, with the row's cells by their column headings and the workbook and table it was added to, for a step that writes back to the row, such as Update table row. Rows already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• New worksheetRuns when a worksheet is added to an Excel workbook, with its name and the workbook it's in, for steps that write to it. Renaming a sheet doesn't start it, and neither do sheets already there when the workflow is turned on. How often it checks follows your workspace plan.

Actions

• List workbooksFind Excel workbooks in your OneDrive or a SharePoint document library.
• Recalculate workbookRecalculate the formulas in a workbook.
• List commentsList the comments in a workbook. Comments can be read here, but not added or replied to.
• Run workbook functionWork out one of Excel's functions (VLOOKUP, SUM, PMT and so on) using a workbook's data, without writing it into a cell.
• List worksheetsList the worksheets in a workbook.
• Get worksheetRead a worksheet's name, position and whether it's visible.

Microsoft Outlook

Triggers

• New emailRuns when a new email arrives in a folder of an Outlook mailbox - the inbox unless you choose another - optionally only from one sender or domain. Runs once for each email, with its text.
• New eventRuns when an event is added to an Outlook calendar, whether someone creates it or accepts an invitation, with its subject, times, location, organizer and guests. Events already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Event updatedRuns when an event on an Outlook calendar changes: its time, subject, place, notes or guests, a guest's answer, or the organizer cancelling it (is_cancelled tells you). Events as they were when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Event starting soonRuns a set number of minutes before each event on an Outlook calendar starts, once for each meeting of a repeating series, with its subject, times, place and guests. Times are in UTC. It checks as often as your workspace plan allows, so it can run a little later than the minutes you set, and up to half an hour after the start if a check comes late. Cancelled events, and events already that close when the workflow is turned on, don't start it.
• New contactRuns when a contact is added to an Outlook mailbox's Contacts, with their name, email, phone numbers and company. Contacts already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.
• Contact updatedRuns when a contact in an Outlook mailbox's Contacts is changed, with their name, email, phone numbers and company as they are now. Contacts as they were when the workflow is turned on don't start it. How often it checks follows your workspace plan.

Actions

• Send emailSend an email from a mailbox in your organization. Sent means Outlook accepted it; a bounce arrives later in the sender's inbox.
• List emailsList the emails in a mailbox, newest first. You can narrow it to one folder, to unread emails, or to a search.
• Get emailRead one email, including its full body.
• Create draftSave a draft email without sending it, to send later with Send draft. Set 'Reply to email' to draft a reply in that email's conversation, with the original quoted below.
• Send draftSend a draft email created earlier. Once sent, it moves to Sent Items and the draft's ID stops working.
• Reply to emailReply to the sender of an email. The reply is saved in Sent Items.