Office Scripts

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.

Office Scripts allows users with all levels of programming experience to automate their repetitive workflows. Use the Action Recorder to generate a script from your recorded actions in the workbook or use the Code Editor to create customized scripts from scratch.

Using Office Scripts and Power Automate, I built a script that fully automates a report that used to take me at least one to two hours per month.

At Analysis Cloud Limited, we’ve used Office Scripts to completely automate a Covid-19 reporting process used by one of our clients. Using Office Scripts meant that an arduous process was reduced to a simple action.

In this 15-minute all user-focused demo, Damien Bird steps through an automated invoice generation scenario using Excel scripts, Power Automate and no tables in Excel. Solution elements include 2 lists containing data and an Excel invoice template with scripts in SharePoint a cloud flow in Power Automate. Flow actions pull data from lists, run script in template to populate an Excel file for each customer, creates pdf invoices. Excel invoices stored in document library, PDF files in OneDrive. This PnP Community demo is taken from the Office Add-ins community call – May 2021, recorded on May 12, 2021.

Take a tour of the new features for Excel and Outlook that will will help you bring your business solutions more seamlessly into Office.

This month's community call features presentations - Update on Keyboard shortcuts (features went to GA on May 12), Update on custom contextual tabs (GA for Excel - web and Win 32), Customer demo: Office Scripts and Power Automate (populate Excel template dynamically to generate excel invoice files), and an Update on Outlook event-based activations - preview (5 new events). This month’s Community spotlight recognizes MVPs Maarten van Stam and Leslie Black. Thank you! Q&A in chat throughout call. The call was hosted by David Chesnut (Microsoft) . Microsoft Presenters: Abid Rahman, Sohail Zafar, Nancy Wang and Juan Balmori. Special guest presenter Damien Bird (DamoBird365). Recorded May 12, 2021.