Excel Online

Common Questions

Excel online is the online version of Microsoft's Excel service. It lets you create and modify workbooks and share them with other users so that multiple users can work on one workbook at the same time. This service works with paid Excel Online accounts only. 



  • New Row

    Triggers when a new row is added to the specified workbook

  • New Sheet

    Triggers when a new sheet is created in the specified workbook of a specific folder

  • New Row In Table

    Triggers when a new row is added to the specified table



  • Add Rows

    Add rows to the specified workbook

  • Add Rows to Table

    Add rows to the specified table

  • Get Rows

    Retrieve rows from the specified workbook

  • Get Table Rows

    Retrieve the rows of the specified table

  • Update Rows

    Update the rows of the specified workbook

Common Questions

To use Excel Online in your flow, you will first need to connect it with Flow. 

To do this, drag any Excel Online action listed under Excel Online service on the canvas. In case of configuring Excel Online triggers, double-click on the Start icon on your canvas and select Excel Online service. Then, click on the Add New option listed under the Authorize Excel Online field in the configuration window. You will be prompted to authorize Flow to access your Excel Online account. Click on ALLOW


After this, you will be prompted to confirm the Microsoft account you wish to use to create the authorization and sign in to it, in case you are not already signed in. Next, you will be redirected to canvas. 


Rename the authorization as per your choice and click the ADD button. You can now see the added authorization under the Authorize Excel Online field. Once added, this authorization will be available in all Excel Online actions and triggers.

The Lookup only fetches workbooks with '.xlsx' extension. If your workbook has '.xls' extension, (in other words, if your workbook was saved as 'Excel 97-2003 workbook') you will first need to convert it to '.xlsx' format for it to be fetched in the lookup.