Microsoft 365

Productivity just got easier with robots that can now collaborate using Microsoft 365 Activities for Excel Online, OneDrive, SharePoint, Outlook Mail & Calendar and Planner.

Introduction to Microsoft 365 as a Cloud-Based Service

Microsoft 365 stands as a cloud-based subscription service that seamlessly integrates a suite of premier tools tailored for contemporary work environments. This comprehensive service amalgamates top-tier applications like Excel and Outlook with robust cloud services such as OneDrive and SharePoint, empowering users to create and collaborate from any location on any device.

Automation with Microsoft 365 Activities Package

The Microsoft 365 activities package facilitates the automation of interactions with Microsoft 365 applications. Leveraging integration with the Microsoft Graph API, these activities empower your robots to:

• manage OneDrive and SharePoint files
• manage SharePoint lists
• create and edit Excel workbooks
• search and send Outlook emails
• manage Outlook calendars
• trigger automations when certain events happen

Categories of Activities in the Microsoft 365 Package

This package encompasses three distinct categories of activities:

Classic activities

• This is the list of activities under each category:
  Excel - Offer methods for creating, extracting, and inserting data into Excel workbooks and worksheets.
  Files - Provide methods for file search, movement, and copying within OneDrive and SharePoint.
  Outlook - Facilitate the retrieval and sending of emails.
  Calendar - Enable the management of calendar events, encompassing the creation of new events, retrieval of events from specific calendars, and updating existing events.
  Groups - Offer methods for managing user groups, such as Microsoft 365 and Security groups, potentially used in conjunction with Planner activities.
  Planner - Provide methods for managing plans, buckets, and tasks.
  SharePoint Lists - Support CRUD operations for SharePoint lists.

Activities

• This is the list of cross-platform activities included in the Microsoft Office 365 activity package, under each category. These activities are also available in Studio Windows projects and use Integration Service connections.
  Calendar Excel Online Files Outlook SharePoint List

Trigger activities

• The following trigger activities are available in the Microsoft 365 activity package:
  Calendar: Calendar Event Created, Calendar Event Invitation Received, Calendar Event Replied, Calendar Event Updated Email: Email Sent, Email Received OneDrive: File Created, File Updated SharePoint: List Item Added, List Item Updated Excel Online: Worksheet Created, Cell in Worksheet Updated, Row Added to the Bottom of a Table

Business Applications and Advantages of Microsoft 365 Activities

The Microsoft 365 activities package offers a range of automation capabilities that can be applied to various business scenarios, streamlining processes and enhancing efficiency, like:

• Document Management and Collaboration
• Workflow Automation for Excel Data
• Email Automation for Customer Interaction
• Calendar Event Management
• Notification and Alerts