Microsoft 365

Connect Excel, SharePoint, and Teams data to create unified dashboards across your Microsoft 365 workspace.

Overview

Integrate Microsoft 365 data sources including Excel workbooks, SharePoint lists, and Teams activity into unified dashboards. Visualize data stored across your Microsoft ecosystem without manual consolidation. Ideal for enterprises standardized on Microsoft tools needing centralized reporting.

How it works

Authenticate with Microsoft 365 and grant Lumis access to Excel, SharePoint, and Teams. Select workbooks and lists to visualize, and Lumis automatically generates appropriate charts based on your data structure. Real-time sync keeps dashboards current as team members update files.

Configure - implementation details

Microsoft Graph API provides unified access across 365 services. Delta queries efficiently sync only changed data, minimizing API calls.

// Microsoft Graph data sync
const client = Client.init({authProvider});

async function syncExcelWorkbook(driveId, itemId) {
  const workbook = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook`)
    .get();
    
  const tables = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook/tables`)
    .get();
    
  return tables.value.map(t => t.rows);
}

// Microsoft Graph data sync
const client = Client.init({authProvider});

async function syncExcelWorkbook(driveId, itemId) {
  const workbook = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook`)
    .get();
    
  const tables = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook/tables`)
    .get();
    
  return tables.value.map(t => t.rows);
}

// Microsoft Graph data sync
const client = Client.init({authProvider});

async function syncExcelWorkbook(driveId, itemId) {
  const workbook = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook`)
    .get();
    
  const tables = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook/tables`)
    .get();
    
  return tables.value.map(t => t.rows);
}

Microsoft 365

Ready to transform your data workflow?

Start for free

See our plans

14 day trial, no credit card required.

Lumis AI SaaS Framer template hero section

Unlock from $129

Get Template

Secured By

Unlock from $129

All Access

Secured By