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.