Скачать с ютуб Dynamically Create Excel Table with Power Automate в хорошем качестве

Dynamically Create Excel Table with Power Automate

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 like OneDrive or SharePoint, for example, and is great for when you get a new batch of data each week in a file that is not yet formatted as a table - just add it and change the name and there you have a nicely formatted table automatically created that dynamically determines the boundaries on the row level! Here is the Excel formula that Jonathon uses to create the table in Excel: =OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),14) 👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jonathon30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - https://pragmaticworks.com/pricing/ 00:00 - Introduction to Dynamically Creating Excel Tables with Power Automate 00:41 - Overview of the Excel Worksheet and the Desire to Dynamically Create Tables 01:14 - Emphasis on Dynamically Formatting Tables Regardless of Row Count 02:07 - Setting Up Power Automate Trigger for Item or File Modification in SharePoint 02:40 - Configuring the "Create Table" Action in Power Automate for Excel Online 03:11 - Utilizing the OFFSET Formula in Excel for Determining Table Range Dynamically 03:41 - Adjusting the OFFSET Formula Parameters, Including the Number of Columns 04:18 - Testing the Power Automate Flow for Dynamically Creating Excel Tables 05:18 - Demonstrating Successful Flow Execution and Checking the Result in Excel 06:26 - Conclusion -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter:   / pragmaticworks   ✔️Facebook:   / pragmaticworks   ✔️Instagram:   / pragmatic.works   ✔️LinkedIn:   / pragmaticworks   ✔️YouTube:    / pragmaticworks   Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks