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

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.

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

[jherschel]

Thanks! I got stuck trying to copy data from one excel table to another and creating a new file helped me through it! Also, I had 26 columns and didn't realize if you dynamically entered the row table Name in add row to table, I was able to copy ALL rows using the row field and current item!

[cgbeale]

Thank you for such an excellent video. I was lost on how to dynamically create a new file, until I watched both of your videos. I love the pace and how you clearly explain everything especially showing the expressions.

[rhodrithomas]

This has been super helpful, thanks! Trying to build a flow for creating distribution lists for documents in a SharePoint library and this is getting me a long way down the line!

[rkobiggestfan]

I can't believe it took me a long time to find this video. This is what I was looking for!

Amazing. Thank you very much! This was helpful

[naderhayek]

Excellent video - very detailed and easy to follow - thank you for taking the time to share

[Kralnor]

Microsoft really should provide better support for creating a new Excel file, but your workaround is a great idea!

[nandnandan]

exactly what I needed. Keep your work up and running.

[amaniramahi]

Cant thank you enough! I've been struggling with creating a table after exporting data from powerBI dataset using (Run query against a dataset). all tutorials were pushing to export it as a CSV file. this video is very clear and the jem i was looking for! Thank you

[anhduong]

Thank you for sharing this video. It was very helpful.

[MitchTorres]

Thanks as always for these perfect demo :) this is just what I wanted to do :) Keep it coming :)

[lucapiu]

Thank you so much, just what I needed!

[XavierAponte-eqhu]

This video helped me do exactly what I needed to! the flow was failing when I used dynamic values from power automate, when I used your item expression in its place it worked perfectly. Thank you

[mamadykonate]

Great Job!
This just saved me from having a lot headache with Excel
Thank you

[notonurnelly]

Really useful Damo, this use case with a few tweaks will be really helpful on a project I am about to start.

[JonDoesFlow]

Nice one, very helpful, thank you Damo !

[weizhang]

Thanks for this. Exactly what I'm looking for. spend hours trying to figure this out!

[yiubili]

Great video, will you do an video that exactly show how to draw data from excel and paste to other excel with condition please? Would be great if the table range are also flexible as well...

[myintzusan]

Thank you so much! This tutorial video has solved my problem. Thanks heaps again!!

[sudarshanreddy]

Thank you so much damobird, I am looking for exactly the same topic

[ngunghuong]

Thank you so much. This is really helpful for me.