Master Power Automate: A Case Study From Start To Finish

Export data from Power BI to Excel and PowerPoint with all formatting using an advanced 55 actions, Power Automate flow

What you'll learn

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

Requirements

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)

Description

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 .