Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email

In this tutorial, I will show how to add data dynamically to an Excel file using the Add a row into a table action from Excel Online connector.
We will dynamically create a Table, add columns by defining the table range & column names and more.
This Power Automate flow pattern can be applied to any data source or service to fetch the data and then do a for each row on the data and add it to the Excel table.
Lastly, we will send an email and attach the generated Excel file.
We will cover the above with examples using SharePoint, Dataverse and Planner as data source.

Topics covered:
✔️ Export to Excel Power Automate flow pattern
✔️ Dynamically Create Table, Add Columns, Add Rows in Excel
✔️ Send email from flow with Excel file attached

🔗 Power Automate Export to Excel Sample flow download link:
https://github.com/rdorrani/Microsoft-Flow/tree/master/Export%20to%20Excel

🔗 John Liu twitter post:

Hack #FlowNinja 86 while playing with Create CSV in @MicrosoftFlow I thought hmm 💡
well well, another hack.

1. Create CSV: automatic header – automatically selects every property name of the first item.
2. So this can be used to perform keys(object) pic.twitter.com/pAXW1r5cv3

— John Liu 劉 (@johnnliu) March 25, 2019

#Microsoft #PowerAutomate #Excel

Table of Contents:
00:00 – Introduction
00:26 – Export data from SharePoint to Excel (Generate the Columns of Excel file)
03:20 – Create Excel file in OneDrive
05:13 – Create Table in Excel (Table Range A1 Notation)
06:29 – Add a row into a Table (Excel)
08:05 – Power Automate Send Excel file in Email
09:34 – Dynamically Add Columns & Create Table in Excel
14:44 – Reusable flow pattern for exporting to Excel
14:56 – Export data from Microsoft Dataverse to Excel using Power Automate
15:47 – Export Tasks data from Planner to Excel using Power Automate
16:19 – Subscribe to Reza Dorrani channel