08-24-2021 06:23 AM
Hello,
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
#Microsoft #PowerAutomate #Excel
watch?v=Kupz71dWYyY