Using Single Sign-On (SSO) with Office Add-ins

Intermediate
Developer
Microsoft 365
Office Add-ins

Office Add-ins can access information from anywhere on the internet, whether from the server that hosts the add-in, from your internal network, or from somewhere else in the cloud. If that information is protected, your add-in needs a way to authenticate your user. Office Add-ins provide many different methods to authenticate using single sign-on (SSO), depending on your specific scenario. In this module, you'll learn how to implement single sign-on (SSO) and call the Microsoft Graph in Word, Excel, and Outlook add-ins.

Learning objectives

By the end of this module, you'll be able to:

  • Understand how Office Add-ins can use SSO to call Microsoft Graph
  • Create Word add-in that uses SSO to call Microsoft Graph
  • Create an Excel add-in that uses SSO to call Microsoft Graph
  • Create an Outlook add-in that uses SSO to call Microsoft Graph

Prerequisites

  • Experience developing web applications
  • Experience using Microsoft Word, Excel, and Outlook
  • Ability to program with JavaScript and Node.js
  • Experience using Visual Studio Code at the beginner level
  • Valid Microsoft 365 subscription