Create a new Excel File in Power Automate and dynamically populate with a Table and Rows

Have you ever needed to create a new Excel File in Power Automate and then populate it with data from another source? Maybe a the results of another action, an API endpoint or the contents of another Excel File that has been filtered? I will demonstrate how to build your own flow in 4 actions and then populate a table with many rows from another data source.

Watch my latest video 👀 Graph vs Office Scripts and a new cleaner method of creating a blank excel file    • Create Excel File and Add Rows Fast |...  

👀 Populate an excel file FAST ⚡with Graph API    • Create and Populate an Excel File Fas...  

👀 Create and populate dynamically all file types from Power Apps    • Create Word, Excel, HTML Documents & ...  

👀 Create Dynamic Word Documents with Optional Sections via Microsoft Forms    • Create Dynamic Word Document with Pow...  

Want to submit an idea or feedback? https://forms.office.com/r/4EqE7VHVfH

See how you can avoid an apply to each using Office Scripts and without the need to setup a table in your excel file first    • Create & Populate Excel File Fast - O...  

00:00 Intro
00:28 Creating an empty Excel File
00:45 Start of the Cloud Flow Build - Getting the File Content
02:15 Creating a new File using the File Content from a Compose
03:17 Create Table Action
04:30 Add a row to the Table with a JSON array
07:05 Saving the Flow, an overview and Testing
08:37 Using an external source to add multiple rows to the Table
11:22 enabling concurrency on the Apply to Each
11:47 Saving the flow and Testing
12:50 Reviewing the flow history
13:34 Summary

#PowerAutomate #Excel #NewExcelFile Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕