This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFU%3C/text%3E%3C/svg%3E)
We see that Microsoft power automate allows users to select and run the automation scripts on the user's excel files. I tried to find any API which allows us to do the same job using an API such as excel Rest API or MS Graph REST API but so far we did not find any such API. I'm not unable to comprehend how is ms power automate achieving it internally if there is no such APIs available?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Hi @ffbld01@uk.ibm.com , Thanks for reaching out.
The feature to run automation script for excel files using MS Graph REST API is not available at the moment, if you want to raise a feature request for it Feature request.
----------
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thanks for the quick response. I was curious to know if not the MS-Graph API, is there any other API that allows running a script over excel files?
Hello @ffbld01@uk.ibm.com ,
As @ Mehtab Siddique (MINDTREE LIMITED) pointed out, we don't yet have an API to directly execute Office Scripts at this moment. But I'd love to hear a bit more about your scenario here. Are you thinking to integrate the Office Script executing capability directly into your app/service?
For a short-term workaround, I am wondering if you would consider creating a Power Automate flow with:
So you probably can treat this flow as a Web API that you can invoke via the HTTP URL of the trigger to indirectly execute the Office Script.
Actually, we are developing a connector kind of app that allows users to execute any already available script in the user's excel file. We have seen similar capabilities in other apps like ms power automate Flow. We were wondering if such APIs are not available, how is MS power automating implementing it?
Thanks for the explanation! I would love to understand a bit more about your scenarios here and see if there is anything available on our side right now that might be helpful for you.
Please feel free to reach out to us if you have any further questions!
@Yutao Huang - MSFT request your attention
Thanks for the clarification!
I'm wondering what the gaps you are seeing in the current Office Scripts experiences inside Excel on the web. From there a user can see all their scripts stored on their OneDrive for Business and they can select any of them to run on any workbook they have access to. It seems to be able to fulfil most of the scenarios you described. But maybe you're thinking to build a custom solution with your own UI then the Office Scripts UI obviously won't help.
At this moment, we don't yet provide a "Run script" API that users can directly consume. As a workaround, you can probably use Microsoft Graph API to discover the script files stored on users' OneDrive for Business (under Documents/Office Scripts), then maybe potentially use an HTTP triggered Power Automate flow to run the script through the "Run script" action.
Our current focus is more on the "no-code/low-code" spectrum so the API capability will probably come later. But we are open to suggestions and feature requests and will definitely adjust our priorities along the way based on customer feedback and requirements. Please feel free to share your thoughts/suggestions using the in-app feedback button in Excel on the web or the Microsoft Feedback portal.