+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Master Power Automate: A Case Study From Start To Finish (/Thread-Master-Power-Automate-A-Case-Study-From-Start-To-Finish)
Master Power Automate: A Case Study From Start To Finish - BaDshaH - 11-16-2023
![[Image: 581c8ce690f961dc05d04a1ffc69c9a8.jpg]](https://i122.fastpic.org/big/2023/1116/a8/581c8ce690f961dc05d04a1ffc69c9a8.jpg)
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.31 GB | Duration: 7h 34m
Export data from Power BI to Excel and PowerPoint with all formatting using an advanced 55 actions, Power Automate flow
[b]What you'll learn[/b]
Build an advanced Power Automate flow from start to finish
Become an advanced and confident Power Automate developer
The Power Automate section is only 3 1/2 hours - you can skip the entire Office script coding section
Quickly grasp the Power Automate way
Quickly get started without long introductions
Watch the 10 min Course walkthrough video to get a detailed description of the Power Automate flow
Learn to implement 22 types of Power Automate actions
The flow handles both small and large datasets
Export your data out of Power BI over to Excel + PowerPoint
Keep all the formatting of the Power BI visual with Office script
Learn Office script (if you want - you can skip all Office script coding)
Take full control of your Power BI exports!
Multiple selections in Power BI slicers are not a problem
Export all possible slicer selections from your Power BI report with Power Automate with one mouse click
[b]Requirements[/b]
Microsoft Power BI needs to be installed (free) - This is not a general Power BI course; it only covers the use of the Power Automate visual
Microsoft 365 Business standard (free one-month trial, you need to provide work or school email address)
If you choose to take the Office script section, then you need only a basic level programming knowledge (basic understanding of if-statements and loops)
[b]Description[/b]
My main goal is to help you understand and master Power Automate and to get your data out of Power BI at the same time! This course was specifically designed for those who want to learn advanced Power Automate from scratch and those who are already working with Power Automate but don't fully understand how it works or want to learn much more.In this course, we will build a complete, advanced Power Automate flow from start to finish. We will use 22 types of actions to set up 55 actions. Each lecture builds on the previous ones as we build the flow, making it easy to follow.We will do:1. If conditions,2. Apply to each loops,3. Do Until loop,4. Delay action to halt the flow, if necessary,5. Parse JSON,6. Run queries against a dataset,7. Select variables to collect results,8. Compose to manipulate the data within Power Automate,9. Initialize, increment, and set variables,10. Create our own loop iterators,11. Output the data to Excel online,12. Run scripts in Excel online,13. Perform several types of OneDrive operations,14. Create PDFs and JPGs,15. Let Power Automate access your file system,16. Set up a PowerPoint show.After this course, you will be able to do a lot of things with Power Automate in your projects. You can create your own advanced Power Automate flows and improve existing ones. If you worked on a project with Power Automate but never dared to touch it or did not understand it, after this course, you will be able to handle it, understand it, and even improve it
You can skip the Office script coding section if you want to focus on the Power Automate sections. You do that by simply copying and pasting the provided Office Script code into Excel online, as shown in Lecture 13: Skipping the Code. Then, the course video playback time drops from 7 1/2 hours to only 3 1/2.I will be constantly updating this course, so you can always be sure that it is up-to-date and covers the latest features of Power Automate.If you have any questions regarding Power Automate or Power BI, please post them in the Q&A section. Many people have already found answers to their questions there, and I will do my best to help you with your questions as well.Take this course if you want to master Power Automate.Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Course Walkthrough
Lecture 3 Initial setup
Section 2: Power BI to Excel
Lecture 4 Let's go!
Lecture 5 Load Power Automate with data
Lecture 6 Run a query against a dataset #1
Lecture 7 Collect the results of the query
Lecture 8 Outputting query results to Excel
Lecture 9 Setting up the slicer values
Lecture 10 Conditional arrays
Lecture 11 Run queries against a dataset #2
Lecture 12 Outputting queries results to Excel
Lecture 13 Skipping the Code
Lecture 14[OPTIONAL] Code walkthrough - formatting
Lecture 15[OPTIONAL] Code walkthrough - splitting
Lecture 16[OPTIONAL] Code walkthrough - rearranging
Lecture 17[OPTIONAL] Conditional formatting
Lecture 18[OPTIONAL] Formatting the product names
Lecture 19[OPTIONAL] Formatting the totals
Lecture 20[OPTIONAL] Preparing for the split
Lecture 21[OPTIONAL] Splitting into new sheets
Lecture 22[OPTIONAL] Splitting - clean up
Lecture 23[OPTIONAL] Rearranging - recording
Lecture 24[OPTIONAL] Rearranging - invoking functions
Lecture 25[OPTIONAL] Rearranging - copy dynamics
Lecture 26 Outputting the resulting Excel file
Section 3: Excel to PowerPoint
Lecture 27 Creating the JPGs
Lecture 28 Access the filesystem
Lecture 29 Do Until
Lecture 30 PowerPoint slide show
Lecture 31 Finish up!
Section 4: Congratulations
Lecture 32 Congratulations
All developers who want to learn advanced Power Automate from scratch to fully understanding how Power Automate works and for those who want to get their data out of Power BI .
Homepage