Office Script - data from Azure AD or MS Graph

Dvorský Jan 1 Reputation point
2022-09-26T10:35:08.993+00:00

Hi,

is it possible to access Azure AD or MS Graph using Office Script. I was using Google script for creating custom reports about Chromebooks, users, etc., or even to manage it, directly in Google sheet. I's possible to Use Excel (and Office Script) get data about devices and it's users into interactive, easily accessible sheet?

Jan

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yutao Huang - MSFT 701 Reputation points Microsoft Employee
    2022-10-04T17:24:27.513+00:00

    @Dvorský Jan - Directly accessing AAD or MS Graph from withing Office Scripts is not supported yet. What you have described sounds like a very powerful scenario/capability. Please feel free to share your ideas here: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472 (or upvote one if it already exists).

    At the same time, you can probably try exploring Power Automate Desktop (or Power Automate Cloud) that can integrate and automate Excel along with other web services (like AAD and MS Graph, etc.).

    0 comments No comments