This month's community call features updates on Excel shortcut customization APIs (introducing 3 new APIs to assist with keyboard shortcuts management), an SSO update for Office Add-in (call to action: add new SSO service in Azure for your SSO enabled add-ins, and Outlook event-based activation on Mac (announcing Mailbox 1.10 APIs and Event-based Add-ins are GA in New Outlook for Mac). This month’s Community spotlight recognizes Eric Legault and Maarten van Stam for their continued contributions to this community. Q&A both at end of call and in chat throughout call. The call was hosted by Alex Jerabek (Microsoft). Recorded January 12, 2022.
What are Office Scripts, target user and usage scenario? In this 19-minute developer focused demo, Nancy Wang explains Office Scripts buttons and how you can get involved evolving Office Scripts. Create buttons in Excel using the Action Recorder (capture actions and record them into a script – great for seeing how the automations are built – includes comments!) or the Code Editor (JS/Type Script call Office Script APIs). Also, Power Automate integration. Automations sharable within tenant. This PnP Community demo is taken from the weekly Microsoft 365 Platform Community call recorded on December 14, 2021.
New Single Sign-on service for Office Add-ins rolling out in Office on the web
A new Single Sign-on (SSO) service will replace the existing one for Office Add-ins that are used in Office on the web. This new service is aimed at providing better reliability and supporting additional environments.
With the Office Add-ins platform, you can extend Excel’s functionality
through a web app that runs within the Excel client on multiple platforms such as Windows,
Office.js. To learn more about creating an Excel add-in with Office.js, see Excel add-ins documentation.
With Microsoft Graph, you can read and modify Excel workbooks that are
stored in OneDrive, SharePoint, or other supported storage platforms. By issuing REST API
requests to Microsoft Graph, your web or mobile application can access Excel objects. To learn
more, see Working with Excel in Microsoft Graph.