Excel Online (Business) Connector(Power Automate Cloud flows)
Contents
Triggers
| Action | Importance | Description |
|---|---|---|
| For a selected row | Middle | Flow can be triggered at any time for specified rows of a table. Requires the add-in to be installed in Excel. |
Actions
| Action | Importance | Description |
|---|---|---|
| Run script | Middle | Run Office scripts stored in Excel. |
| Create table | Low | Create a new table by specifying a cell range. |
| Get tables | Middle | Get information on all tables existing in the book. |
| Add a row into a table | High | Add a new row to the table. |
| Get a row | High | Specify search conditions and retrieve one row of data from the table. |
| Update a row | High | Specify search conditions and update one row of data from the table. |
| Add a key column to a table | Middle | Add a single column item to the table. |
| Delete a row | High | Specify search conditions and dedate one row of data from the table. |
| List rows present in a table | High | Get all rows of data in table. |
| Create worksheet | Low | Create a new worksheet. |
| Get worksheets | Low | Get information on all worksheets existing in the book. |