Outlook
Connect Outlook or Microsoft 365 to build dashboards, apps, reports and workflows on the messages in your mailbox and shared mailboxes.
Read only access to the messages in your Outlook mailbox and any shared mailbox you can open. Nothing is sent, moved, marked or deleted.
Objects
Each mailbox is one dataset of messages.
| Column | Meaning |
|---|---|
id, thread_id | The message and the conversation it belongs to |
received_at, sent_at | When it arrived and when it was sent |
from_name, from_email | The sender |
to, cc | Recipient addresses, comma separated |
subject, snippet, body_text | Subject, Outlook's preview, and the body as plain text, capped in length |
folder | The folder it sits in, such as Inbox or Inbox/Clients |
is_read, is_draft, has_attachments | Read state, draft state, and whether attachments are present |
importance, categories | Outlook importance and any categories applied |
web_link | Opens the message in Outlook on the web |
mailbox | Which mailbox the row came from |
Attachments themselves are not read.
Scopes
Delegated Microsoft Graph permissions, all read only:
Mail.Read
Mail.Read.Shared
User.Read
offline_accessMail.Read.Shared covers shared mailboxes. Flitch reads a shared mailbox with the same access you have in Outlook, so a mailbox you cannot open there is not readable here either.
Connect
Open Data
In app.flitch.io, open the Data page.
Add Outlook
Top right, click Add, pick Outlook.
Shared mailboxes
Optional. Enter the address of each shared mailbox you want, separated by commas. Your own mailbox is always included.
Sign in with Microsoft
Complete the Microsoft sign-in popup. A work or school account may ask an administrator to approve the connection first.
Pick mailboxes and save
Tick the mailboxes you want. Set a name. Save.
Each mailbox becomes a dataset.
Refresh
The first read takes the newest messages within the fetch budget. Each scheduled refresh asks Microsoft only for mail that arrived since the newest message already stored, and adds it to the dataset, so the history builds up over time instead of being re-read. Enable refresh to keep it current. See Refresh.
Disconnect
- In Flitch: open the connection from the Data page and delete it. Token revoked, stored mail cleared.
- In Microsoft: for a work or school account, myapps.microsoft.com, find Flitch and remove it. For a personal account, account.live.com/consent/Manage.
Troubleshooting
Needs admin approval. Your organisation requires an administrator to approve apps before people can sign in. Ask them to approve Flitch from the same screen, or to grant it from Microsoft Entra, Enterprise applications.
Shared mailbox is empty or refused. You cannot open that mailbox in Outlook either, or its address was mistyped. Open the connection, click Reconnect and enter the address again.
Reconnect required. The token was revoked or expired. Open the connection and click Reconnect.
Fewer messages than expected on the first read. The first read is bounded by the fetch budget and takes the newest mail. Enable refresh and the rest fills in on later runs.