Office 365

Office 365 Developer Newsletter – March 2018

March 2018

Upcoming events

Tech Summit


April 17-18, 2018


Tech Summit


April 25-26, 2018


Office Add-ins

Community call

April 11, 2018

Details here

Microsoft Graph Community call

April 3, 2018

Details here

SharePoint Saturday Events

Dates vary

Details here


Community call

April 10, 2018

Details here

Join us at Microsoft Build, May 7-9

Our ultimate developer conference is just around the corner in Seattle, WA. Thousands of developers from across the globe will gather to get an exclusive look at what’s next in on the Office 365 developer platform, including Microsoft Graph, SharePoint, Microsoft Teams, Outlook, Excel and more. Don’t miss out, register today.


Microsoft Graph

In a community first, Yina Arenas and the Microsoft Graph team broadcast the monthly Microsoft Graph community call live from the 2018 MVP Summit in Redmond, WA. We were joined by over a dozen MVPs who were treated to a catered breakfast and some cool Graph swag. Microsoft engineer Caitlin Bales shared our new Java SDK and showed a demo of a OneNote integration scenario.

The rest of the community call was about our MVPs, who shared how they use Microsoft Graph to create new value and efficiency for organizations. MVP Paul Schaeflein shared how he uses the Microsoft Graph APIs to create modern office add-ins. MVP Mikael Svenson, CTO of Puzzlepart, demonstrated how his team uses Microsoft Graph for Groups management automation. MVP Paolo Pialorsi showed how he’s using Microsoft Graph to enable Teams provisioning scenarios. Finally – big thanks to our community contributors: Sahil Malik, John Liu, Giuliano De Luca, Paolo Pialorsi, Joshua King, and Tony Phillips.

  • Video can be found here
  • Presentation can be found here

Microsoft Teams

In another first, we ran a Microsoft Teams community call featuring Microsoft Teams Platform Architect Bill Bliss. Bill gave a Teams Platform overview and highlighted Line of Business (LOB) App Scenarios with a live demo of a sample HR recruiting tool app to demonstrate possibilities in the LOB space. A lively Q&A followed. Look for an announcement on Twitter for our next call.

  • Video can be found here
  • Presentation can be found here


In the February SharePoint Dev Ecosystem / Patterns and Practices community call, we covered the latest news on the SharePoint Development area within the past month (see monthly summary). Monthly community calls consist of the SharePoint engineering summary around what’s the latest guidance and samples on the SharePoint development. We also acknowledge all community contributors on the SharePoint development topics. Thank you for your contributions for the benefit of others!

February call had 3 specific demos. Paolo Pialorsi demonstrated upcoming improvements on the SharePoint Framework for accessing additional Microsoft Graph scopes. Andrew Connell did an introduction to Office 365 CLI tool. Bert Jansen showed how to modify modern pages content and controls using APIs.

  • Video can be found here
  • The presentation used for the vide can be found here

Content updates


Craft effective AppSource store images


Script Lab code snippets that use ExcelAPI 1.7:

New: Active cell, Worksheet copy, Workbook and worksheet protection, Chart series (doughnutHoleSize), Plot order, Chart substrings, Axis vertical and horizontal formatting, Data Validation, Create additional chart types

Updated: Table changed event, Table Collection changed event, Worksheet changed event.

New content

Office versions and requirement sets

Build an Excel add-in using Vue

PowerPoint add-in tutorial

Word add-in tutorial

Outlook add-ins API requirement set 1.6

Updated: Build an Excel add-in using Angular

Microsoft Graph

Microsoft Graph Java SDK Preview

Microsoft Graph Community Call: February 6, 2018

Microsoft Teams

New templates to create huddle solutions in Microsoft Teams and Office 365


Now Releasing – Enhanced preview support for Microsoft Graph API calls from SharePoint Framework

SharePoint PnP Webcast – SharePoint Framework Dialog Framework

SharePoint Patterns & Practices – February 2018 update

SharePoint Dev Ecosystem / Patterns and Practices – February 2018 monthly community call recording

SharePoint PnP Webcast – Upgrading Packages in SharePoint Framework Solutions

New SharePoint CSOM version released for SharePoint Online – February 2018

SharePoint PnP Webcast – Introduction to Office 365 CLI

Extending SharePoint Patterns and Practices team with new MVP community members

SharePoint PnP Webcast – Using MSGraphClient within SharePoint Framework

SharePoint PnP Webcast – Consuming SHarePoint Online via the Microsoft Graph

SharePoint Patterns and Practices – March 2018 update

SharePoint Dev Ecosystem / Patterns and Practices – March 2018 monthly community call recording


Word add-in tutorial

Meet the community

Meet Bryan. Bryan won the best use of Microsoft Graph in the Productivity Hack 3 with his Modelo solution.


  1. What is the coolest Office 365 developer feature for you? Open APIs in is the coolest “feature” in the sense that they enable developers to interact and engage with a community that was previously not accessible.
  2. What school did you graduate from? University of Rochester
  3. What’s your favorite city to live in? My current home, New York City!
  4. What did you want to be when you were a kid? Any engineer.  I loved K-nex as a kid.  I think my first obsession was over cars.  Then when Halo 2 was released for Xbox I thought “okay, this is the coolest thing, I need to make video games for a living.”  Now, I feel I’ve found the best tool available today for engineers and builders – software.
  5. Which words or phrases do you most over-use? Why does this API’s architecture make no sense?
  6. Which talent would you most like to have? To be able to accurately predict how long programming tasks will take.
  7. Where would you most like to live? Outside of my home in New York City, I suppose somewhere totally different.  Maybe in rural East Asia?  My only requirement is internet connectivity.
  8. What is your most treasured possession? My computer
  9. What is your most marked characteristic? My friends joke that I’m an actual computer, so I suppose it’s my lack of personality.
  10. Spaces or tabs? Tabs, obviously.