Create Excel Tables for Your ENTIRE Workbook ⚡️SUPER FAST⚡️ with THIS Automation!

Formatting Excel data into a table can be done with a few clicks. If you have a workbook with multiple sheets of data all needing to be formatted into a table-it would take too many clicks.
In this video tutorial I will show you how add a script to Excel that will format all of the data in your entire workbook into tables. You can even customize the table style. This time saving automation will allow you to quickly create multiple tables with a single click.
This tutorial will also cover how to use the Run Script action in a Power Automate flow to completely automate adding Excel data into a SharePoint list. I will show you how to dynamically select an Excel file and table.
Note: This video does not cover how to write a script for Excel. It’s available for you to copy and paste using the link down below.
---
IN THIS VIDEO:
✅ How to Add a Script to Microsoft Excel
✅ How to Create Multiple Excel Tables Quickly
✅ How to use the Run Script action in Microsoft Power Automate
✅ How to import data from Excel into a SharePoint List with a Power Automate Flow
✅ How to Use the Get Tables Action
✅ How to Use a Dynamic Table Name and File Name in the List Rows Present in a Table Action
✅ How to Copy an Power Automate Action and Reuse It
---
SKIP AHEAD:
0:00 Intro
0:23 Add a Script to Excel
0:34 Run a Script in Your Flow
4:01 Get the Table Name
5:07 Get the Table Data
6:38 Create a SharePoint List Item
7:41 Customize the Table Style
----
THINGS YOU’LL NEED FOR THE FLOW:
Excel Table Maker Script: bit.ly/44cBsZJ
---
INSIGHTS:
- If you want to fully automate the flow, use When a File is Created (properties only) Action to trigger the flow.
- You can adjust the script to change the syntax of the table names. Tip: Use ChatGPT to help you out with this! Test out your script in Excel first before running your flow.
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #productivityhabits #troubleshooting #microsoftflow #sharepoint #sharepointonline #microsoftexcel #microsoftexceltips #microsoftexceltutorial #microsoftexceltutorialyoutube #automation #workflowautomation
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop

[@florianboissiere6211]

Awesome!

[@billypham3024]

Great video, can you do a video that uses Power Automate to read information from a PDF file and show a result in PVA? Thanks.

[@acreativeopinion]

🤖 What other automaton scripts do you use in Excel? 👇👇👇