Add A Row Into An Excel Table Onedrive In Power Automate

Introduction

Most of the common usage of storing data in Excel Spreadsheets and a common scenario was to add data into Spread Sheet. We can use an action Add A row into a Table in Power Automate under connector Excel Online (Business). As an example, Employee details will be passed to Spreadsheet through Power Automate.

Step 1

Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the left-hand side as shown in the below figure.

Step 2

After Step 1, Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.

Step 3

After Step 2, open OneDrive and create a spreadsheet with name Employee and name sheet name as Employee_Details and then provide column names as Sno, Name, Email, Address and then under insert tab click on table and observe all the columns will get a filter beside them which infers a table was constructed and then click on save as shown in the below figure.

Step 4

After Step 3, go back to the flow and then name it as Add A row into a Excel Table Onedrive and then select Excel Online (Business) connector and establish required connection as shown in the below figure.

Step 5

After Step 4, under Excel Online (Business) select Action Add a row into a Table as shown in the below figure.

Step 6

After Step 5, under Manual trigger a flow provide inputs as per columns that are provided in Spreadsheet as shown in the below figure.

Step 7

After Step 6, go back to add a row into a table and provide the following values as

Location : OneDriveforBusiness
Document Library: One Drive
File : ExcelWorkBooks/Employee.xlsx
Table : Table1
Sno : Sno [From Manually Trigger ]
Name : Name [From Manually Trigger ]
Email : Email[From Manually Trigger ]
Address: Address[From Manually Trigger ]

And then click on save as shown in the below figure.

Step 8

After Step 7, Test and run the flow by providing the inputs and click on run flow as shown in the below figure

Step 9

After Step 8, now navigate back to the excel sheet and observe employee data with the above details populated post flow runs successfully as shown in the below figure

Note

1. Make sure during Excel Online (Business) Connection establishment a popup window will be shown and if asked provide details and wait till that authentication popup window automatically gets closed.
2. In the spreadsheet, make sure you go into insert tab and then select table then only Table will be available in flow to select, here in our case Table1 was shown only after following mentioned process.
3. As an example one drive was considered, but other options of Excel spreadsheets like SharePoint, etc also can be worked out.

Conclusion

In this way, we can add a row into an Excel Table in power automate easily.