Feature Requests and Feedback
-
Support webhook for Microsoft Teams using Graph API
Customer want O365 Teams to support webhook so it can push events to 3rd party security vendors to perform real-time inspection on the email conversation in private Teams
O365 Teams Graph API doesn’t support webhook for email conversation, so users are not confident to communicate via Teams as it lacks the protection of TM-CAS supplementary security.
3 votesGroup conversations already have support for change notifications. This document here explains how to set up a subscription https://developer.microsoft.com/en-us/graph/docs/concepts/webhooks . More information on Groups can be seen here too https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/conversation.
Please clarify more if you feel this doesn’t support your scenario.
-
memberOf
GraphExplorer is nice tool - why not give a way for ordinary non-admin end user ability to see which sharepoint they are member of?
3 votesThis is actually in the product already https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/user_list_memberof
-
Create a mail enabled security group with graph api
At this moment it's not possible to create a mail enabled security group using the graph API
49 votesThis can be done by creating an Office 365 Group (https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/groups-overview) and set securityEnabled to true (https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/group_post_groups) ^JT
-
Custom properties for Excel Addin
We can read/update custom properties in Word. It would be great if we can have similar function in Excel also.
27 votes -
Expose Delve API and PowerShell
Expose Delve API and PowerShell
5 votesThe insights api on Microsoft Graph allows you to replicate what is in the Delve experience with the API calls. https://developer.microsoft.com/en-us/graph/docs/concepts/social-intel-concept-overview
-
Worksheet password protection
We are also concerned about the issue mentioned on this post:
http://stackoverflow.com/questions/38847193/excel-office-add-in-api-worksheet-protection-password
Currently we are able to protect and unprotect a worksheet. What we need is an API for password protection of worksheets which the end user would not know as this is will make the worksheets on OneDrive more secure for use.
21 voteswe now support both workbook and sheet pwd protection
chek https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheetprotection?view=office-js#protect-options--password-enjoy!!!
-
Add https://graph.microsoft.com/<version>/me/OwnerOf
Similar to me/memberOf call we need an me/ownerOf call to get a list of all Groups that a person is the owner of.
14 votesThank you for your input! This is already supported. Please see: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/user_list_ownedobjects and give us feedback.
Thanks,
Office Extensibility Team -
API for host information
We need host information for tracking environments and reproducing errors.
The method with requirements checking and the undocumented feature with reading the sessionStorage or querystring are painful as requirements change and undocumented features disappear.Office.js could provide an API for this, as its internally use host information to load custom host scripts.
1 voteThanks for this suggestion! You can obtain host information from the Context object. There’s more information here: https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/context.md
Please take a look and let us know if you have any feedback.Thanks,
Office Extensibility Team -
coreclr
please create a version of the Microsoft Graph SDK that allows use by .net core platform
3 votesThank you for your input! This is already supported. Please see: https://www.nuget.org/packages/Microsoft.Graph and give us feedback.
Thanks,
Office Extensibility Team -
Allow Officejs to open external excel workbook programatically
There should be a way to open a external excel workbook by providing URL for that file on excel online via officejs. so that user can open a template stored on some other server which contains desired formatting and named-ranges which can be modified on Excel Online
51 votesThis API is now available in production!
Here is a sample snippet
https://gist.github.com/JuaneloJuanelo/399608d6928f6183b474af8f1f7e1c8aKey instruction: Excel.createWorkbook(mybase64);
please enjoy!!!
-
Implement Conditional Formatting Editing
The ability to edit conditional formatting in OfficeJS Excel API.
21 votesWe shipped this as part of 1.6. Extensive support for conditional formatting.
check https://docs.microsoft.com/en-us/javascript/api/excel/excel.range?view=office-js#conditionalformats
-
Excel - Add CopyWorksheet
We have a need to repeat the same formatted Worksheet over and over based on selections made by the user. It would be great to setup a template so that same worksheet can be copied. The worksheet has all formatting including printing stuff in place already. Be great to just be able to copy that and fill in the data.
44 votesThis is now available in the API! check
https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheet?view=office-js#copy-positiontype--relativeto-we also have in preview inserting sheets from other workbooks, please check this sample (remember is PREVIEW)
https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a -
Expose Workbook events via Excel JavaScript API
Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):
Activate,Deactivate
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetActivate,SheetDeactivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetChange
SheetSelectionChange154 votesGlad to report that Many of the events asked here are GA!
please check this pageto see details;
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-eventsWe are still to provide (other are in, please try them!)
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetBeforeDoubleClick
SheetBeforeRightClickthanks!
-
Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.
Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.
The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.
Could you please let us know if it's possible to add this method to JavaScript API for Excel?
114 votesnow we have this API please use it!
here the details: https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/worksheet.md#copypositiontype-worksheetpositiontype-relativeto-worksheetworksheetObject.copy(positionType, relativeTo);
Copy a worksheet and place it at the specified position. Return the copied worksheet.
Enjoy!
-
Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values
Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.
37 votesthis was shipped as part of our Data Validation feature! please try it!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.listdatavalidation?view=office-js -
Provide access to CustomXMLParts for Excel via JS APIs
It will be good to have access to CustomXmlParts for Excel via JS APIs. Currently it supported only by Word. It allows developers to provide coolest plug-ins for Excel 365.
18 votesThis is shipped as part of 1.5!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.workbook?view=office-js#customxmlparts
Enjoy!!!
-
Make ItemAttachment content available through Office 365 Mail REST API
I've been having a lot of success using the Office 365 Mail REST API. However, when trying to retrieve email messages that are attached to other emails (i.e., Item Attachments like .msg files), the REST API does not deliver.
When I make a GET request like this for an email that has a .msg file attached to it, I get all the attachment properties *except* the "Item" property, which should contain the attachment (according to the Office 365 Mail API resource guide: https://msdn.microsoft.com/office/office365/APi/complex-types-for-mail-contacts-calendar#RESTAPIResourcesItemAttachment)
GET: https://outlook.office365.com/api/v1.0/me/messages/{messageid}/attachments
RESPONSE:
{
"@odata.context": "https://outlook.office365.com/api/v1.0/$metadata#Me/{messageid}/Attachments",
"value": [
{
"@odata.type": "#Microsoft.OutlookServices.ItemAttachment",
"@odata.id": "https://outlook.office365.com/api/v1.0/Users('{useremailaddress}')/{messageid}/Attachments('{messageid}')"…8 votesThanks to Venkat for answering the question in Stack Overflow. ^JT
-
Triggers for Onedrive for Business on IFTTT
I'd like to be notified on our Slack channel about new files being added to a specific folder on Onedrive for Business. A trigger for new files would help!
10 votesApologies for delay on this. There are IFTTT services for OneDrive for Business here https://ifttt.com/services/onedrive_for_business ^JT
-
Office 365 Unified APi support for "External Users"
Office 365 supports "External users" if the external user has a Microsoft or work/school type of account.
But the Office 365 Unified API doesn't support login and showing what the "external user" has shared to them through the Unified API (https://graph.microsoft.com/beta/me)
I would like to be able to add a user to Azure AD, and provide the same login process as other Office 365 users, and then my Azure Web App can show them a customized view of what has been shared with them through the Unified API.
24 votesThanks for this feedback! We do support a “guest” type of user which should work. There’s more about it in the documentation here: https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user
If this doesn’t work then please let us know on this request thread.
Thanks!
Office Extensibility Team -
Method for determing which Office Application an Add-In is running in
Currently, an Add-In can be setup to be runnable in Excel, Word, PowerPoint, etc...
There are certain API features that are available to some of the Office Applications but not others; In addition, the availability of these features differ based on platform (fat clients, web, ipad, etc...). As such, we may choose to use TableData for an Add-In that is loaded in Excel, but HTML for the same Add-In loaded in Word.
Right now, we use the context.document.url property to determine the application, looking for the ",xls" extension in it.It's not a complete solution but it is getting us by…
17 votesHi Paul, thank you for the suggestion. This information is already available on the API. There’s more information in the documentation at: https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/context.md
Thanks,
Office Extensibility Team
- Don't see your idea?