Data sources
Office 365 To Do
The Office 365 To Do data source lets you read the tasks of a Microsoft To Do task list that is hosted on Microsoft 365. Sign-in uses modern Microsoft authentication (Microsoft Entra ID, OAuth) with a choice between a multi-tenant and a single-tenant application.
Setting up the data source
Right-click [Data] or click the […] button and choose [Add data source]. Switch to the [Office 365] category (1) and select the [To Do] data source (2).
Configure the connection
Give the data source a name, then set up the [Connection]. Picking the authorization method, signing in with [Authorize] and reusing an existing connection work the same for all Office 365 data sources and are described once here: Office 365 connection.
Specify details
Click [Retrieve To Do tasks list] (2) to load the task lists you have access to. Choose the list under [Task list] (3) – in this example [Factory CI].
Load data and output columns
Click [Load data] to display the preview. The result is a list containing one line per task with the following columns:
- Id – the unique identifier of the task.
- Title – the title of the task.
- Status – the task status, for example
notStarted,inProgressorcompleted. - Importance – the priority of the task:
low,normalorhigh. - Content – the body / notes of the task.
- Created Date – the time the task was created.
- Completed Date – the time the task was completed; empty as long as the task is not completed.
- Due Date – the due date of the task; empty if no due date is set.
- Categories – the categories assigned to the task.
- Has Attachments – indicates whether the task has attachments (
true/false).
Click [OK] to create the data source. It then appears in the Explorer under [Data] and can be linked to controls like any other data source.
