Microsoft Graph Feature Requests
Welcome to the Microsoft Graph UserVoice! Do you have an idea or feature suggestion based on your experience with Microsoft Graph? Please share these with us by submitting your idea below or voting up ideas submitted by other users. This forum will be directly monitored by the Microsoft Graph engineering teams who are working on new features every day.
If you have feedback on a specific API service, please choose the corresponding category. Please submit any broad ideas related to Microsoft Graph or ideas across more than one service to the “General” category.
This site is only for feature suggestions and ideas! If you need technical help, please go to the Microsoft Graph StackOverflow or if you have a Premier support contract raise a support ticket.
For more information on Microsoft Graph, please checkout https://graph.microsoft.com.
-
New workbook creation functionality
Function for creating new workbook. Currently feature is available only to work with existing workbook
3 votes -
WYSIWYG for Cells using Graph Explorer API
While copying and pasting any coloured text/ texts with only few words highlighted or underlined, it works good when directly done on the UI. But there is no option to do that using REST API, the closest which can be done is applying to the contents of the whole cell. I have discussed the idea here with pics too.. https://docs.microsoft.com/en-us/answers/questions/187518/wysiwyg-for-sharepoint-graph-explorer-api.html https://stackoverflow.com/questions/65134435/wysiwyg-for-sharepoint-graph-explorer-api
1 vote -
Call Excel REST API using app only permissions
I would like to be able to call the Excel REST API using app only permissions.
My use case is to have excel workbooks with models that have complex calculations. I could then use then call the Excel REST API from say an Azure Function using a Managed Identity that first populates some cells (that are parameters so to speak) and then calculates the workbook and gets the result from another cell, so basically I can delegate the "programming" of the complex model to a finance user who knows how to build complex models in excel.
I would effectively be…
10 votes -
Download content of a workbook in a sessionID
I create a new Workbook session and change some values. After done, I would like to download the changed workbook. However the item download/convert api does not allow to download a workbook in a session, so I always get back the original, unchanged workbook.
So please allow to download a workbook in a session.2 votes -
24/7 Data share through linked cells
The ability that data linked between sheets (either web or desktop app) are updated constantly without having to open the files to refresh the connection.
1 vote -
create workbook
Create a new workbook
4 votes -
Add support for inserting images
The API currently has no way to insert images into a worksheet.
2 votes -
Add support to change worksheet tab color
The API currently has no way to change the tab color for a worksheet.
1 vote -
Graph REST API for Excel - Add support for data validation
Our application is heavily dependent on the data validation feature, especially using the list validation. There is no Graph API to set the validation for a given range.
6 votes -
Graph REST API for Excel - Add support for querying the Excel file status on OneDrive
As Graph API user, I want an API to query the status of the Excel file being edited on OneDrive, so that I am able to delete it once my work is done. For example, we use Graph API to delete the file, but it failed due to “locked”. Another example is that the UsedRange API returns the range which is not updated to the latest.
Refer https://docs.microsoft.com/en-us/graph/api/range-usedrange?view=graph-rest-beta&tabs=cs
3 votes -
Graph REST API for Excel - Add Support for text orientation in a cell
Text orientation, for example, rotate the text vertically, is required by the user.
3 votes -
Support column names while creating a new table
Currently, when creating a new table in a worksheet using the instructions at https://docs.microsoft.com/en-us/graph/api/tablecollection-add?view=graph-rest-1.0&tabs=http, you can't provide table column header names. I currently have to:
- Create a table POST /tables/add (address e.g. A1:G1 for 7 columns)
- Get table colums with GET /tables/{ID}/columns
- Patch each column with a column name PATCH /tables/{ID}/columns/{ID} (7x in this case)Would be great if we could provide the column names on table creation already.
1 vote -
Graph REST API for Excel - Add support for open Excel file (xlsx) on OneDrive using internet browser
Our application work-flow is using the Graph API to upload the excel file to OneDrive, open it with internet browser (Internet Explorer, Edge, chrome ...) Then the user changes the content of Excel file, closed the browser, and our code downloads the Excel file from OneDrive.
Currently there is no Graph API to support using any internet browser to open Excel file on OneDrive.
2 votes -
Add ability to SET Calculation Mode
Beta now adds ability to GET Calculation Mode and to Calculate, but we would like to also SET the Calculation Mode. This should allow us to improve performance of setting multiple ranges (without dependsOn and small batches).
2 votes -
Freeze panes support
It would be nice we could have the same functionality in Microsoft Graph as the freeze panes in Excel worksheets. It's been commonly available in other APIs for Office clients and add-ins.
3 votes -
Micro soft Excel best program ever
very challenging at the beggining stilll quite a ways to go but very efficent Thank You Microsoft
1 vote -
thumbnail
Be able to retrieve thumbnails of Excel documents. This feature works great with Word documents and other types, but really needs to expanded to work with excel
4 votes -
Call Macros using Microsoft Graph
I would like to run Excel Macros through the Microsoft Graph Excel API. I read through the documentation but couldn't find anything related to Macros. Is there a way of executing my Excel Macros somehow via Microsoft Graph?
4 votes -
Graph REST API for Excel -- Add support for OneDrive Personal
With Azure AD 2.0 Endpoint, Graph API now supports OneDrive personal (in addition to OneDrive for Business). However the Excel API does not yet support OneDrive personal -- we would like it to.
See http://stackoverflow.com/questions/40121236/graph-excel-rest-api-azure-ad-2-0-endpoint-is-onedrive-personal-supported8 votes -
Input-Output functions in Microsoft graph (excel) api
Detailed Question:
https://stackoverflow.com/questions/52245424/how-to-create-custom-input-output-functions-in-microsoft-graph-excel-api/52246534For Example :
Cells A1 to A10 has some data
Cell B1 is an input field
Cell C1 is an output field whose value is a functions of A:1 to A:10 and B1 ex: C1 = SUM(A1:A10)/B1Is is possible to use Microsoft graph API(or any other api) to send the input data in the form on HTTP request parameter and get the result as the response of the request ?
An Ideal request-response would look something like :
http://path-to-workbook/path-to-response-data?parameterB1=someNumericValue
Response:
{
C1: <result of calculation>
}1 vote
- Don't see your idea?