Microsoft Power Automate Desktop - Beginners Course 2023

Learn Power Automate Desktop in less than two hours on this 2023 beginners course. In the real-time tutorial, you and I will build a complete web scraping project with advanced features. Very easy to understand, yet you'll learn the Power Automate Desktop practices.

Power Automate Desktop is the Microsoft RPA software and free from Windows 11.

POWER AUTOMATE DESKTOP GROUPS:
- Join my network with 5600+ Automation/RPA developers, where we solve Automation/RPA problems, and network, and help each other upgrade our careers. It's free!

FOLLOW ME:

0:00:00 Intro and Overview
Learn to open Power Automate Desktop, pin it to the tray, and create a flow.

0:01:25 Applications and Basic Power Automate Desktop
With the Run Application, we specify an application path, and then Power Automate Desktop will open any application. We can click any UI element with the Click UI Element in window action. The address of the UI element is called a selector. In the UI elements, we can edit the selector. You'll learn how to create a dynamic selector - a selector with a variable in. To save the data from the application, we use the Extract data from window action. Using the Get subtext, we can extract the text we need from a series of characters. Next, we create a log with a date and time and look at error handling (On error and Label).

0:34:07 Open Browser and Do a Search
The Launch new Chrome/Edge/Firefox actions, with a URL in the parameters, will open a website of your choice. The populate text field on web page action lets you type into web page fields. To perform the search, we send an enter click with the Send keys action.

0:38:17 Web Scraping to Excel
With the Extract data from web page action, we can extract any structured web data with Microsoft Power Automate Desktop. The scraped data is stored in a DataTable variable, and we write it in Excel.

56:16 Extract Multiple Pages With a Next Button
We inspect the CSS code for the Next button. Power Automate Desktop uses CSS selectors, so little knowledge about that is preferred. When we have it, we use a Loop condition action, and in the loop, an If web page contains action to keep clicking the Next button and extract the next page. Unfortunately, there is no direct way to join two DataTables in Power Automate Desktop, so we create a workaround.

1:10:27 Error-Handling
With the On error property and the Label action, we handle errors in our Power Automate Desktop flow.

1:12:44 For Each Excel Row do Web Searches
We use a For each action to loop an Excel sheet and then perform web searches.

1:22:00 Advanced CSS Selector Work
We need to know about CSS selectors to customize our scraped data from an Extract data from a web page.

1:34:18 VBScript in Power Automate Desktop
Scripting knowledge is beneficial as a Power Automate Desktop developer. However, I recommend VBScript over Python and JavaScript because it integrates well with Microsoft. Use the VBScript action and copy the script from the course page (link above).

1:38:37 Create an Advanced Log
Finally, we create an advanced log with runtime date and time and a detailed log that displays the transactions that are successful and with errors. Finally, we can email the complete log with the Send email message through Outlook.

#powerautomate #powerplatform #microsoft365

[andersjensenorg]

I'm blown away by all your nice feedback ❤

[daveys]

Fantastic example Anders! Covers a lot of possibilities and shows in enough detail to allow implementation too. Thanks!

[transcendwebs]

Liked and subscribed. Worked through both this video, and UIpath video of yours as well, fantastic work, thank you so much Anders! You've got a new follower from Canada, learning a ton from you!

[andersjensenorg]

Thanks for all your support and likes 🙌🔥

[JeriAnnCherek]

Anders, thank you very much for creating this course. It is SUPER useful and goes into elegant and simple best practices that I have not seen elsewhere. I really appreciate that you provide really useful learnings from the very first minute - no time wasted, and the detail is amazing. Your video surpasses anything I found on Microsoft Learn, Udemy or YouTube. You give me hope that I can become a GREAT citizen developer. Well done on the content and many, many thanks!

[SunilKumar-uwni]

Dear Anders, I am completely new to this automation field and don't have any background like coding or technical. But your videos are great to watch as you explain in easy ways. I really like your teaching skills which helps beginners to learn or adapt these tools. Thanks a lot.

[dambad]

Anders, as I said in the past, within the UIPATH series, you're really spectacular as a teacher. It's impossible not to understand you. Great stuff for me, my collaborators and my Master's students.
Best!

[gobonafellah]

Woooow, this tutorial is awesome, for my first encounter with RPA Iv learnt a lot. Feeling like a master already

[billk]

These videos are the best! Thank you so much for doing them and making them available. I’ve struggled with Power Automate. You course touches on all the things I’ve struggled with. As a non=programmer also very appreciative of all the Best Practices tips.

[lawrence]

Happy new year to you Anders, and to you all!

[NickWindham]

Great updated video. Appreciate your content SO much!

[ismayilisgandarli]

Awesome tutorials ! Thank you so much for creating such a helpful content 🙂

[PeacefulTunesChannel]

Hi Anders, i have just started out learning Power Automate Desktop Flows and i can't thank you enough for making such a wonderful beginners series on the topic. You make it so easy to learn, while elaborating and touching down on all the crucial aspects of the various flow actions and their outcomes. i have managed to create some few basic flows with the help of your videos and now i am stuck at a point where i need some guidance to complete the flow.

[robertrosenwald]

I think I can honestly say that this is the best video tutorial that I have ever encountered

[kaltoumadnane]

thank you, I have learned a lot from your videos in Power Automate

[kebincui]

Excellent! 👍👍Thanks Anders for sharing

[kensleylewis]

This whole course is the truth as of 2023 with PAD - Nice work.

[ivoradulovic]

Great one. I've already passed your similar YT tutorial, but this one has some new useful details. Tnx! 👍

[vilimmt]

This is a beginner course? I can't wait to see what an advanced course looks like 😄 Thanks for your time and work. Great tutorial. Always something new to learn from you, even from a "beginner course"

[versacedan]

Hi Anders things got a bit intense at around 1 hour with the loops. The first one was ok, but after that I got lost. I've done some of your UIPath videos and that seems an easier product to get your head around. Not sure if that's just me! Will have another go and see if I can follow! Keep up the good work!