Microsoft 365

Linetrack in Microsoft 365, explained for your IT.

This page is written for the IT department. It shows where Linetrack works with Microsoft 365: Copilot in Teams, sign-in through Microsoft Entra ID, absences from Outlook, Excel and MS Project, Power BI and Power Automate. For each building block it also states which permissions it needs. For sign-in, that is only openid, profile and email.

Ready-made connectionCopilot app in the Copilot StoreSign-in through Entra IDNo access to mail or files

Microsoft 365 website ↗

In short

Linetrack works with Microsoft 365 in several places. The administrator deploys the Linetrack app for Microsoft Copilot from the Copilot Store once for the tenant, and users sign in with "Continue with Microsoft" through Microsoft Entra ID. For this Linetrack requests only openid, profile and email and accesses neither mail nor files. Absences come in as a calendar export from Outlook, Excel and MS Project through import and export, Power BI and Power Automate through the APIs.

Building blocks

Where Linetrack meets Microsoft 365

The building blocks can be introduced one at a time. For your IT's review, each one states what it needs and what it does not access.

CopilotTeams

Linetrack app for Microsoft Copilot

The app is in the Copilot Store. Your Microsoft 365 administrator deploys it once for the tenant, after which project managers ask about dates, project status and capacity in the Copilot chat in Teams. Each of them signs in with their own Linetrack login and only gets answers from what they are allowed to see in Linetrack.

  • Copilot Store
  • Deployed per tenant
  • Licence "KI-Assistent"
  • Own Linetrack login

More: Integrations → Microsoft Copilot

SSOEntra ID

Sign in with Microsoft

The sign-in page in the browser and on mobile offers "Continue with Microsoft". Linetrack uses Microsoft Entra ID for this and requests only the scopes openid, profile and email. Linetrack does not call Microsoft Graph; mailboxes, calendars and files are left alone.

  • openid
  • profile
  • email
  • No Microsoft Graph
  • Web and mobile
Identity

Matching the accounts

On first sign-in Linetrack matches the Microsoft account to the Linetrack user by email address. After that it recognises the user by their immutable Entra identity. Personal Microsoft accounts such as outlook.com are not allowed by default.

  • First sign-in by email
  • Stable Entra identity
  • Personal accounts off
Outlook.ics

Absences from Outlook

Anyone who keeps holidays and business trips in their Outlook calendar exports it as an .ics file and reads it into Linetrack. All-day events marked as busy from today onwards are taken over. In the preview you choose what is imported, and existing absences stay as they are.

  • .ics
  • All-day
  • Busy
  • From today
  • Preview

Where in Linetrack: "Abwesenheiten verwalten" → "Abwesenheiten importieren"

ExcelMS Project

Excel and MS Project

Project plans, users, absences and machines come into Linetrack through Excel templates, and utilisation per resource group goes back out as .xlsx with a chart. Linetrack reads MS Project plans as .mpp or XML and exports them as MS Project XML.

  • .xlsx
  • .mpp
  • MS Project XML
  • Excel chart

More: Integrations → Excel and MS Project

Power BIPower Automate

Power BI and Power Automate

Power BI reads KPIs per project, company and resource group through the KPI API and refreshes them on a schedule. Power Automate calls the REST API with its HTTP action, triggered by SharePoint, Forms, Teams or a schedule. Both work with their own API key in the X-API-KEY header, enabled only for the scopes they need.

  • KPI API
  • REST API
  • X-API-KEY
  • Scopes per area

More: Integrations → Power BI and Power Automate

What this makes possible

What your IT gets out of it, and what the departments do

A security review without surprises

Before the rollout, the head of IT checks which permissions Linetrack gets in the tenant. For sign-in it is openid, profile and email; access to mail, calendars or OneDrive is not part of it. That keeps the approval a manageable review.

Sign-in rules from Entra ID

Employees sign in with their Microsoft work account, under the rules your IT has set in Entra ID, multi-factor authentication for example. If a project manager's email address changes after she marries, her account stays connected through the Entra identity.

Copilot for project management

The administrator deploys the Linetrack app once for the tenant. The next morning a project manager types in Teams: "Which electrical design tasks for line 3 are overdue?" The answer comes from his projects in Linetrack.

A new order from the SharePoint list

Sales keeps won orders in a SharePoint list. A Power Automate flow uses the REST API to create the project in Linetrack from it, from the matching template and with the order number. The next day the project manager finds a project with its schedule already in place.

Trade fair days from Outlook

A sales engineer keeps holidays and trade fair days in his Outlook calendar. Before the quarter's capacity planning he exports the calendar as .ics and reads it into Linetrack. The all-day events then show as absences in the resource view.

Schedule adherence in a Power BI report

Plant controlling builds a Power BI report with schedule adherence per project and over- and under-coverage per resource group. The figures come through the KPI API and refresh on a schedule. Management opens the report where they look for it anyway, in Teams or the Power BI portal.

How it works

How your IT introduces the building blocks

  1. 1

    Sign in with Microsoft

    Users are created in Linetrack with their company email, by hand or via Excel. On the first "Continue with Microsoft", Linetrack connects the account, and from then on the Entra identity applies.

  2. 2

    Deploy the Copilot app

    The administrator deploys the Linetrack app from the Copilot Store for the tenant. Users with the "KI-Assistent" licence connect it to their Linetrack login.

  3. 3

    API keys for Power BI and Power Automate

    Each connected system gets its own API key with exactly the scopes it needs, kpis:read for the report, for example.

  4. 4

    One joint session

    We go through the setup with your IT in one session and answer the questions from your security review.

FAQ

Frequently asked questions

Any questions?

Book a call with our team.

Which permissions does sign-in with Microsoft request?

Only openid, profile and email, that is the sign-in itself, the name and the email address. Linetrack does not call Microsoft Graph and has no access to mailboxes, calendars, OneDrive or SharePoint.

Can employees sign in with personal Microsoft accounts?

Not by default. Personal accounts such as outlook.com are switched off; users sign in with your company's work account.

Does Linetrack sync the Outlook calendar continuously?

No. Absences come in as an .ics export from Outlook, which an employee reads into Linetrack. For an ongoing sync with time tracking or an HR system there is the REST API.

What does the administrator have to do for Copilot?

Deploy the Linetrack app from the Copilot Store once for the tenant. Employees then sign in to Linetrack from the Copilot chat with their own login and need the "KI-Assistent" licence, plus the Ressourcenplanung licence for questions about company-wide capacity. The details are on the Microsoft Copilot page.

The platforms and brands mentioned belong to their respective owners. Mentioning them describes the technical connection and does not imply a partnership or certification.