When setting Values or Formulas (and the sisters of the Formulas property), according to the docs we're supposed to pass an array of Any[][]: https://learn.microsoft.com/en-us/javascript/api/excel/excel.range?view=excel-js-preview#excel-excel-range-values-member This means that code like this fails to compile in VSCode:   async function run() { await Excel.run(async (context) => { const sheet = context.workbook.worksheets.getActiveWorksheet(); const rng = sheet.getRange("A1:A10"); rng.formulas = "=B1"; await context.sync(); }); }   If you change the "=B1" to [["=B1"]], the code compiles but fails with a runtime error because the # of array elements doesn't match the # of rows of the range. HOWEVER, the code shown above runs just fine in Script lab and produces the expected result where A1 gets the formula =B1, A2 gets =B2 , and etcetera.   Setting one formula to an entire range is a very frequent task in Excel automation and should be made as simple as it is in VBA, .NET and in Script lab.   I am asking for a change in the limitations imposed by the Office parts of VS Code (whatever those are called) that disallow setting a single value to the formulas and values of an entire range. ... View more

In the classic Outlook I can add Inbox folders of shared mailboxes to Favorites, easily detecting and accessing new emails sent to any of mailboxes I manage. In the new Monarch Outlook, this is no longer possible as only my personal folders can be added to Favorites. ... View more

Currently all trusted app domains must be listed fully qualified in the manifest, e.g. <AppDomain>https://customer1.acme-eu.com</AppDomain> <AppDomain>https://customer2.acme-eu.com</AppDomain>  <AppDomain>https://customer3.acme-us.com</AppDomain> <AppDomain>https://customer4.acme-us.com</AppDomain>    Our company has several root domains for their customer tenants. In the example above acme-eu.com and acme-us.com.   But as these customer tenant URLs (e.g. https://customer2.acme-eu.com) are sensitive data we can not put them in our delivered add-in manifest because all other customers would have the chance to see them.   Currently our customers need to use the O365CentralizedAddInDeployment PowerShell command to configure additional domains before using our add-in which is extremely error prone and sometimes just not working. Many hours of support needs to be invested to get the configuration fixed. For example after every change in the configuration all users needs to manually clear their add-in cache in Excel.   Having wildcards in the manifest would enormously help us and our customers: <AppDomain>https://*.acme-eu.com</AppDomain> <AppDomain>https://*.acme-us.com</AppDomain>   During add-in submission Microsoft can validate that the used domains are trustful. ... View more

Since Microsoft released “Roaming Signatures” it has been expected that there will come support for this in the Graph API, so that external applications, for instance IAM systems, can update signatures on behalf of all users in a company. Here is link to a discussion regarding this. Here is link to an inquiry from the feedback portal. From the discussion where it says that the support for this is on the roadmap, however no one can say when it will be released.   We are in desperate need for this API-support as the application we use now for managing signatures has EOL later this year, and it does not support Exchange Online due to this lack of API-support. Our organization (approx. 8000+ users) will then loose the managed signatures. This is particularly bad since we are facing a transition to the New Outlook. We hope sincerely that Microsoft will prioritize this and release support for Roaming Signatures within the Graph API very soon. ... View more

It would be nice if Outlook provides an event for incoming email. I have checked the list of supported events at https://learn.microsoft.com/en-us/office/dev/add-ins/outlook/autolaunch . Strangely i couldn't find an event which accurs when a new mail arrived. I am requesting this feature because i am working on a add-in on which i want to perform certain actions on the incoming emails like mark it read or move to a certain folder  etc. ... View more

Context We are working on an add-in focused on Formatting. Our specific need involves identifying textual and stylistic discrepancies within shapes, like font or size inconsistencies. The Office JS API limits us.   Pain It's not possible to detect formatting zones within a shape's TextRange.   Example Imagine a scenario where the text range reads "Hello World!" with the second word in bold: Accessing the root text range's formatting doesn't reveal this bold formatting. While getSubstring offers a workaround, determining the correct indices to identify the bold section becomes a guessing game. Obtaining a comprehensive view of formatting requires scanning the entire text range character by character.   Request Could we streamline this process by accessing a list of formatting ranges? ... View more

We need to use Get-CsOnlineApplicationInstance for one of our unattended scripts. Many of our customers have asked us to move from user based authentication to application authentication. However, Get-CsOnlineApplicationInstance will not work with application authentication.   https://learn.microsoft.com/en-us/MicrosoftTeams/teams-powershell-application-authentication#cmdlets-supported   Please support the use of Get-CsOnlineApplicationInstance with application authentication. ... View more

Previously one could add members to mail-enabled security groups via Graph API. But turns out that was a bug, and it was fixed some weeks ago removing this functionality. Would it be possible to allow add-remove of members in mail-enabled security groups via Graph API? ... View more

For our application we are using the Graph API to fetch all rooms in a tenant with application permissions.   Rooms that are marked as "Hidden from GAL" can currently not be retrieved via the Places API endpoint (GET /places/microsoft.graph.room). Therefore it is currently not possible to get those "hidden" rooms via the Graph API in any way whatsoever.   It would be nice to have the Places API to also return "hidden" rooms along with a new property on the room resource type (e.g. "HiddenFromGAL") which would signalize that flag.   ... View more

Currently only delegated user permissions are supported, and this is very sub-optimal for bots and service applications that need to monitor Teams presence of users.   ... View more

Hello,   We're using Interop version 15.0.4795.1000 to process Excel workbooks. As part of this, we highlight some cells. We have noticed that applying the highlighting will cause the undo stack to be cleared and all undo records are lost. This also happens when setting the value of a cell. Is there any way to avoid the issue or any plans to support preserving the undo stack?   Thank you ... View more

I am trying to set up a developer sandbox for 365 and i just keep receiving I dont qualify message. It makes no sense why this is happening and there is nothing that clarifies what you need to do to qualify. Please can somebody assist with setting up a sandbox. ... View more

Support to load Excel containing chart data using Office.js. workbook.insertWorksheetsFromBase64 API does not load excel with chart data.  Charts are commonly used inside Excel.  ... View more

Hi!   I want to lern more about MS 365 by learn-platform from Microsoft. So they wrote there, to sign up to developers network an get the free E5 license for learning purposes.    So i signed up, everything works as written everywhere, but after the "3 forms to fill out", when it switches to the dashboard, nothing more happes.   Everywhere i have looked on videos (tutorials) then there should come up a screen to create (choose between the 2 options) the sandbox. But this does not happen here.   I also have received the welcome-message, where they also say that the next step is to add a new subscription on the dashboard, to set up a sandbox. But it is not possible/shown.   I will show you a screenshot of what i will get/see.   Hope that someone can help me, because at MS support chat, they could not. They told me 2 times that i will get a callback from someone who is responsible, but nothing happened... :(   ... View more

Similar to the SharePoint Permissions dataset, we would like a dataset for PowerBI to get insights in permissions and sharing of datasets, reports, apps and the workspaces.   https://github.com/microsoftgraph/dataconnect-solutions/blob/main/Datasets/data-connect-dataset-sharepointpermissions.md  ... View more

At the moment, only user permissions are available, making building enterprise scale applications integrating Teams with Planner very difficult, with less than ideal workarounds (such as adding a service user to every Team). ... View more

Are there any plans to support adding and modifying RepeatingSection content controls through the OfficeJS APIs? What could be the expected timeline for such a feature? ... View more

It would be great to have a dataset for the applications within Entra ID (Azure AD). For example 2 datasets; one for Service Principals objects (or App integration or Enterprise app), and another one for the Application objects (App registration). If the datasets could contain configuration such as the permissions, information about certificate and secrets, exposed api's, assigned users and owners.. you could create great PowerBI reports for insights. For example you have a PowerBI dashboard showing which applications are linked to each other via permissions and exposed APIs( like a spider web Or a view of certificates and secrets with the expire dates (if that data would be store via Data Connect, we could create automated alerts if something is about to expire, there is nothing built-in for this). ... View more

I've been trying to create an account on Microsoft 365 developer program but for the country selection, India option in not available. So the verification process could not be completed as country code of India cannot be used. ... View more