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’.

Power Automate

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.

For any Help or Queries Contact us on info@crmonce.com or +919014146800