How to Add Rows to Excel using Power Automate

Power Automate:

In this Power Automate tutorial, we will see how to add rows to Excel in Power Automate. Here we are going to cover the below examples:

*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

Step_1: Log in to Power Automate, click on +Create, and select ‘Automated Cloud flow’.

Then provide the flow name and select the ‘When an item is created’ trigger action. Then click on Create

Now you can see ‘When a new response is submitted‘ action is added to the flow. Then provide the below information:

*Form Id: Select the Form from the dropdown.

Step_2:

Next, click on the +New step, to get the response details, so select the ‘Get response details‘ action. Then provide the below information:

*Form Id: Select the Form from the dropdown.
*Response id: Select the response id from the dynamic content.

Step_3:Next, click on the +New step, then select the ‘Add a row into a table‘ action. Then provide the below information:

*Location: Select the Location of the Excel file
*Document Library: Select the document library Excel file is present
*File: Select the Excel file
*Table: Select the table of the 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.

Step 4: Next click on Save and test the flow manually, for this click on the Test icon, -> Manually -> click on the Test button. Next, connect to the credential, and then click on the Continue button -> Next click on the Run Flow button -> click on Done.

*Next, fill the form and click on submit, you can see flow ran successfully. Now the data is added to the Excel table.