How to create a table inside Microsoft Excel using Power Automate-Flow

Imagine you have an excel sheet with some content that you want to read the from Power Automate, but the data is not in a table. In this video you will learn how to create an excel table around the data in excel sheet.

Discount coupons for my courses on Udemy

Contact me

[AlirezaAliabadi]

I clearly understand many of you want to have a mechanism to find the range dynamically inside Excel worksheet or at least knowing the rows. I am afraid Power Automate does not support that. If you are interested, please let me know and I make another video that shows you how to frame the table around data without knowing the number of rows.

[sashawarchoon]

Glad to hear that new course is coming... by the way it's been 4 weeks since this video was released...

[michaelohene-marfo]

You make power automate so easy, you have changed my workflow for the better. 😃😃😃🙌🏽🙌🏽🙌🏽🙌🏽🙌🏽

[gerfer]

Thumbs up from me- ... ?? how to you get the current range without knowing the last row, to prevent hard codling please

[SGUploaded]

Thanks this really help me a lot. I was looking for tons of information to get power automate to read my excel file and didnt know the "Create Table" function was actually meant to create table and not a new worksheet. Thanks a lot!!!!

[sundrapillay]

Thank you Alireza for your time and effort for sharing

[franknielsen]

Wow wow wow - Alireza, this just saved my day 😊👌

[zr_coOL]

Great tutorial. I am just starting to use power automate to reduce repetitive task in my work. I tried this but on a flow which splits a workbook with multiple worksheets to single sheet workbook, create table and convert to csv. However i am having issue on "create table" if used to an "apply to each" loop. The error is "Another table already exists with the name '(dynamic name)' or the name is invalid" . The dynamic name is a combination of the worksheet name + the filename of the source file with appended date in which I assume this would make it unique. The apply to each loops 5x and only works on the first run. When it executes the 2nd to 5th run, the name issue occurs. Any help from the community is gladly appreciated. Thanks in advance.

[richbeeww]

This is great on the example of creating header for playground tab. I would like to check if my row start from A1 and i would like to add a header, is it still possible? THanks.

[nova]

Thanks for Sharing this 👍 Just one query though. What if we don't know the range? is there a way to dynamically get the range of the excel sheet as well?

[aarinwalker]

Thank you for this video. Very well done and easy to understand. When I try to recreate the flow, I get an error status: 404 with message: "Item not found". I am sing a dynamic content in the *File field of the "Create table" connector. When I check the error details, the file name is spot on and everything else seems to be correct as well. There is surprisingly little on this kind of error in the powerautomate community forum. Any help would be appreciated

[milleniummoney]

Hey I was wondering to ask. If let's say I use the desktop ui flow and I make use of the connectors in that page does that give access to excel on my desktop

[mothilalthanickachalam]

Hi Buddy, thanks for the video..


Query of mine...

From SP list and using filtered list data can send that attachment over mail..
Even in excel or csv file...
Thanks in advance Buddy..

[kuanyongchong]

Dear Alireza, thank you for this create table video.
Im from singapore. Is it possible to 'create table' followed by 'apply to each' action created in a single power automate? Reason is i have 2 maintain 2 separate power automate files to achieve the same result. It would be good if i can streamline these 2 flows into one. Thank you.

[AssassinUK]

Nice but ... the aim to to do it NOT knowing how many rows and columns you have. data changes, I need to automatically work that out.

[rapspolo]

I am trying to recreate a similar scenario. the difference is that the number of records in the tables varies, so I don't have a specific range. the number of columns if known and never changes.

[jamesjackson]

Is there a way to automate table creations for files added to a specific Folder?

I'm trying to create a flow where I get an email attachment from a certain address it automatically moves the file to one drive and convert the excel file to a table so I can manipulate the data in power automate.

[jamesjackson]

Great video, but it seems as if it is more effort to automate the creation of one table vs. just manually doing it. I wish this were more scalable - i.e. update all excel files in a folder to tables.

[sundrapillay]

Hi Alireza can you please create a power automate to create folder and break inheritance and grant a user permission

[Pcontracts]

THIS - is what I need. can you tell me how to reference the nost recent file added to a folder for execution ? (is that covered in another video?)