App Connect

 View Only

Using IBM® App Connect to interact with Microsoft To Do

By Shahmini Arumugam posted Thu September 14, 2023 02:29 AM

  

Co-author – Srihari Ananda Kumar 

Microsoft To Do is a task management application that helps you manage daily tasks and remain organized. To-do tasks are grouped in task lists, which can be viewed from any device using To-Do clients, Outlook, and Teams.

Building a flow in IBM App Connect with Microsoft To Do

Use App Connect to build flows that integrate with Microsoft To Do and other applications. The connector is displayed as Microsoft To Do on the App Connect User Interface (UI). 

To allow App Connect to connect to your Microsoft To Do account, you need to complete the connection fields that you see in the App Connect Designer Catalog page or flow editor.

For more information on connection fields, see How to use App Connect with Microsoft To Do.

Microsoft To Do objects 

The following are the Microsoft To Do objects that can be run in App Connect.

Objects

Description

Checklist items

You can add a checklist to a task; checklist items are separate tasks within a checklist.

File attachments

You can add context to Microsoft To Do by uploading an image, document, or any other file to a task. The Microsoft To Do supports all file types.

Lists

You can create new lists for tasks or activities and add the items to those lists. You can choose to attach files to items.

Tasks

You can organize tasks in task lists, which can be viewed from any device across To Do clients, Outlook, and Teams.

Scenario 1: Create a task on the Microsoft To Do list using information retrieved from Microsoft Excel Online

Consider this scenario where you use App Connect to create a new task in a list on Microsoft To Do whenever a new row is appended in Microsoft Excel Online. A new list is created if the list doesn’t exist in Microsoft To Do based on the information retrieved from the Microsoft Excel Online worksheet. A task is then added to the newly created list. Otherwise, if the list already exists in Microsoft To Do, the task will be added to that list.

In this example, we have a Microsoft Excel Online worksheet saved with the task details such as Task name, Description, Due date, and Connector columns.

In this flow:

  1. The event-driven flow is triggered whenever a new row is appended to the Microsoft Excel Online worksheet.
  2. The Microsoft To Do Retrieve lists operation retrieves the information from the specified Microsoft Excel Online worksheet whenever a new row is appended.

    For example, the information from column D (Connector), is being retrieved.


  3. If the connector does not exist in the Microsoft To Do list, a list is created based on the information (column D) retrieved from the Microsoft Excel Online worksheet. A task is then added to the newly created list.

    A Slack message gets sent to the intended channel to notify them that a new list and task have been created in Microsoft To Do.

  4. Otherwise, if the list already exists in the Microsoft To Do list, the task will be added to that list with the information retrieved from the Microsoft Excel Online worksheet. 

    A Slack message gets sent to the intended channel to notify it that a new task has been created in Microsoft To Do.

Resources

Try out our templates

You can view the following use cases in the Templates gallery in your App Connect Designer instance.

The following use cases are available in the Templates gallery on App Connect Designer.

  •  Create a task in Microsoft To Do when a new task is created in Asana

    Template URL: https://<your-instance-id>/templates/Create%20a%20task%20in%20Microsoft%20To%20Do%20when%20a%20new%20task%20is%20created%20in%20Asana

  • Create a task in a list in Microsoft To Do When a lead is created in Salesforce
    Template URL: https://<your-instance-id>/templates/Create%20a%20task%20in%20a%20list%20in%20Microsoft%20To%20Do%20when%20a%20lead%20is%20created%20in%20Salesforce

  • Create a task in Microsoft To Do when a new ticket is created in Zendesk Service
    Template URL: https://<your-instance-id>/templates/Create%20a%20task%20in%20a%20list%20in%20Microsoft%20To%20Do%20when%20a%20new%20ticket%20is%20created%20in%20Zendesk%20Service

  • Create a task in Microsoft To Do when a new event is created in Google Calendar
    Template URL: https://<your-instance-id>/templates/Create%20a%20task%20in%20Microsoft%20To%20Do%20when%20a%20new%20event%20is%20created%20in%20Google%20Calendar

  • Create a task in a list in Microsoft To Do based on the information retrieved from Microsoft Excel Online
    Template URL: https://<your-instance-id>/templates/Create%20a%20task%20in%20a%20list%20in%20Microsoft%20To%20Do%20based%20on%20the%20information%20retrieved%20from%20Microsoft%20Excel%20Online

You must enable the Designer AI features in your containerized environment to access the App Connect templates. For more information, see The preloaded IBM App Connect templates.

You can also import these use cases directly into your App Connect Designer. These templates are added to a public GitHub repository at https://github.com/ot4i/app-connect-templates/tree/cp4i-templates/resources. For more information about the supported connectors, see App Connect Connectors.

For any inquiries on this blog or connector, contact Srihari at srihakum@in.ibm.com.

0 comments
41 views

Permalink