In his tutorial, Jonathon presents a method to dynamically create an Excel table using Power Automate when the file is modified. Applicable to virtually any data source or service that stores files like OneDrive or SharePoint, it proves particularly useful for regularly updated data files not originally formatted as tabled data. With this method, the user can add new data, change the name, and automatically get a neatly formatted table that dynamically determines boundaries at row level.
Power Automate's capabilities go beyond dynamic table creation in Excel. It can automate workflows, simplify tasks, and improve productivity across numerous applications and services. Power Automate allows you to create automated workflows between your desired apps and services to get notifications, synchronize files, collect data, and more. With Jonathon's tutorial as a starting point, you can further explore the power and potential of Power Automate in your everyday functions.
In this tutorial, Jonathon shows how to dynamically create an Excel table using Power Automate when the file is modified. This method can be applied to practically any data source or service that stores the file, such as OneDrive or SharePoint, for example. The Excel formula Jonathon uses to create the table is =OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),14). This tutorial is great for when you get a new batch of data each week in a file that is not yet formatted as a table, as you can just add it and change the name and the table will be automatically created with dynamic boundaries on the row level.
Power Automate, Excel Table, OneDrive, SharePoint, Power BI