You’re offline. This is a read only version of the page.
We have a folder where an Excel file is dropped in SPO about every two weeks. It has tons of columns and rows, but not in table format.
I've looked at the Create table action in Power Automate, but it requires a specific file instead of just looking in a folder. Is there dynamic content or an expression that can be used to create the table in a newly created file in the folder without specifying a file name?
Below is how I would likely build this.
See full flow below. I'll go into each of the actions.
I would use the trigger When a file is created (properties only) so each time you upload/create a new Excel file it will trigger the flow. In my trigger below it's looking for new files in my Documents library within the folder called Drop Excel Files - so any file created in that folder (including within subfolders) will work.
In addition - I would also add a Trigger Condition to ensure the flow only runs if the file uploaded is an Excel file. To do this, go into Settings then add a Trigger Condition and use the following expression.
Share
Report
All responses (
Answers (
@endsWith(triggerOutputs()?['body/{FilenameWithExtension}'], '.xlsx')
For the Table - As long as your Excel file has the table content starting at cell A1 and the first row contains your headers, then this should dynamically select your range of data and use the existing column headers.
=$A$1:INDEX($1:$1048576,COUNTA($A:$A),COUNTA(1:$1))
I am familiar with the DoD and these are a different type of script - you might want to try.....
Another option is for you to rename the files via a Flow when they are uploaded. This will allow you to specify a specific file in the Create table action. Then, after the table is created, rename it again to what is was. If you use this approach, you'll likely need to use a number of pauses or a loop as you will probably see file in use errors.
You probably want to take a look at using Office script to create the table. The script can be executed from Power Automate when a new item is added to the folder.
#1
Michael E. Gernaey
66
Super User 2025 Season 1
#2
stampcoin
65
#3
rzaneti
41
Super User 2025 Season 1
