Live training: next batches coming soon. Join the waitlist:Waitlists open:Developer Training →Developer →Copilot Studio Training →Copilot Studio →

How to Add Rows to Excel in Power Automate?

As a Power Automate developer, sometimes, you might need to add rows to Excel in Power Automate. In this tutorial, I will explain how to add rows to Excel in Power Automate.

We will also discuss the following points:

  • Power automate add a row to excel
  • Add a row to the Excel table dynamically in Power Automate
  • Power automate add a row to Excel from the form
  • Add a row to Excel from email in Power Automate
  • Add a row to Excel from an array in Power Automate

Let’s start with our first topic ‘Power automate add a row to Excel’ to understand what it is and how to use it.

Add a row to Excel in Power Automate

To add a row to Excel using Power Automate, we used the action ‘Add a row into a table’. This action allows us to add a new row to the Exel table.

For example, we have created an Instant cloud flow, in this flow, when we run, it will ask four inputs i.e.

  • Product Id
  • Product Name
  • Product Description
  • Product Price

To save this input in the Excel table, we will create the ‘Add a row into a table’ action and then add it to the Excel below. This Excel also contains the above column.

Power automate add row to excel

Login to Power Automate to create an Instant cloud flow -> choose the trigger as Manually trigger a flow action.

Now, you can see Manually trigger a flow is added, expand it, click on Add an input, then add the below user input field:

Microsoft Power automate add row to excel

Next, we will add a row of data in Excel, so click on the +New step and select the ‘Add a row into a table’ action. Then provide the below information:

  • Location: Select the Location of Excel file
  • Document Library: Select the document library Excel file is present
  • File: Select the Excel file
  • Table: Select the table of Excel file
  • Product Id: Select the Product Id from dynamic content.
  • Product name: Select the Product name from the dynamic content
  • Product Description: Select the product description from the dynamic content
  • Product price: Select the Product price from the dynamic content.
Microsoft flow add row to excel

Now let’s save the flow and run it manually, then fill out the below form. Click on Run flow.

How to add row to excel using Microsoft flow

You can see your flow ran successfully, and the data is entered to Excel.

How to add row to excel using Microsoft Power Automate

Check out Power Apps Modern Form Control

Add a row to an Excel table dynamically in Power Automate

Here, we will see how to add a row to an Excel table from the SharePoint list using Power Automate.

For this example, we will also use the same Excel sheet, ‘Product Information,’ to add a row of data. However, when an item is created in the below SharePoint list i.e. Product Details list, then it will add a row to the Excel.

So, our Excel contains the below columns:

  • Title: Single Line of text
  • Product Name: Single line of text
  • Product Description: multiple line of text
  • Product Price : Currency