Power Automate Desktop Tutorial for Beginners | Zero to Hero
HTML-код
- Опубликовано: 26 июн 2024
- In this complete Power Automate Desktop beginners course you will learn all the basics about PAD! Within the first 15 minutes you will already build your first Power Automate flow!
⭐️ Links to the resources ⭐
🔗 Install Power Automate Desktop on Windows 10: learn.microsoft.com/en-us/pow...
🔗 Navigate to the Course Material: www.powerautomatetutorials.co...
🔗 Chapter 5: Date & Time Formatting: learn.microsoft.com/en-us/dot...
🔗 Download Contoso App: github.com/MicrosoftDocs/msle...
⭐️ Chapters ⭐
00:00 - Introduction
00:18 - Install Microsoft Power Automate Desktop for free
Do you know you can use Power Automate Desktop for free if you're using Windows 10 or 11? I'll show you how to download PAD for Windows 10. If you're running Windows 11 it's already installed on your PC!
02:41 - Automate your first process with Power Automate Desktop
Don't know where to start with Power Automate? In this chapter we automate an easy and basic process in the web browser.
16:12 - Excel Automation with Power Automate Desktop
Excel is the most used business application in the world! If you want to automate business processes, you probably have to connect to Excel. Power Automate easily integrated with Microsoft Excel.
34:34 - Web Scraping with Power Automate Desktop
Do you want to scrape structured data from the internet? That's called "web scraping", and it's really easy with Power Automate!
54:52 - How to use variables in Power Automate Desktop
Variables help you to get data from one part of the flow to another. You find them in different flavors, such as strings (words) or numbers (integers). In this chapter you learn how to use variables in Power Automate Desktop!
1:16:49 - Using Date & Time variables in Power Automate Desktop
DateTime variables are a special variable type. They can help you to calculate future or past dates, check whether a date is in the past or in the future and way more!
1:33:17 - Using Files & Folders in Power Automate Desktop
Files and folders are easy to automate with Power Automate Desktop. It's easy to create, copy or delete files with the Power Automate activities.
1:43:01 - How to automate Desktop Applications with Power Automate Desktop?
In this chapter we'll automate our first Desktop application with Power Automate Desktop: the Contoso app.
⭐️ Follow me ⭐
💼 LinkedIn: / thomas--janssen
🧡 Instagram: TomsTechAcademy
⭐️ More information about Power Automate Desktop ⭐
Power Automate Desktop extends the capabilities of Power Automate by providing a Robotic Process Automation (RPA) tool. If you run Windows 10 or Windows 11 you can access Power Automate Desktop (PAD) for free. For Windows 10 you can download the application for free. Power Automate Desktop is already installed on Windows 11 computers.
Do you want to scrape structured data from the internet? Automate mundane tasks within Excel? Automatically process PDF files and let your robot reply to e-mails from co-workers? Power Automate Desktop allows you to automate these tasks for free, and all with an easy to use drag-and-drop interface!
#powerautomate #powerautomatedesktop #roboticprocessautomation
![Power Automate Desktop Tutorial for Beginners [2024]](http://i.ytimg.com/vi/B0cHOdBv7Jg/mqdefault.jpg)
Thanks for the great chapters in your video desc! This tells me what I might learn from this video.
Thank you for your comment, glad you like my videos :)
Thanks- this video was of value to me, and I look forward to power automating my work tasks!
Glad it was helpful!
Excellent job Tom! Liked and Subscribed.
Thank you Ryan 🙏 glad this tutorial was helpful for you. Happy automation 🚀
Hi Thomas, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails.
As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver.
Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow.
Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.
Hi Thiago,
Thanks for your comment - and apologies for my late reply.
The functionality you're looking for is "generate random number".
Let's say you have 10 drivers - you can represent these drivers by a number from 0 till 9.
Then could create logic similar to this:
1) Generate a number between 0 and 9
2 ) Check whether this driver is available
3) If the driver is not available, generate another number and try again.
Of course you need more extensive logic to handle this process - but this should get you started :)
@@TomsTechAcademy Hi Thomas, how are you? thank you very much for your attention. This is a little complicated for my level of knowledge. Do you provide automation services? If I pay you could you do this for me? Thank you!
Hi Thiago, can you post more details in my discord? I will try to help you as good as I can (for free): discord.gg/a4qUrRuZ
@@TomsTechAcademy thank you so much!
Great tutorial. Have searched and seen several (4) tutorials and one course previously, and this video has been THE most helpful, Currently in Chapter 3, but could not wait to congratulate you. Thank you
Thank you Carlos, it means a lot to me that you liked my PAD tutorial the most from all the tutorials you have seen. Keep up the good work with learning PAD, and let me know in case you need a helping hand! All the best, Thomas
For ch 3, the Flow only gets the first page of items over and over again and puts them in the spreadsheet. In your video you click the "Anchor 2" button which doesn't seem correct. When I get my Flow to try to find and click the Next button that doesn't work either. It still gets page 1 of the "Touch" products over and over again, with the Nokia 123 item, and appends the first page of items to the spreadsheet over and over.
Ok I got it working but I don't know how to share the code with others.
In the if statement "If CurrentItem IsEmpty then exit" the Flow is getting employee numbers for rows 10-12 but there are no employee names there. I tried using the condition IsBlank but that still adds the numbers for blank employees. Is there a way to make sure the name length is > 0? How would we fix this?
I also tried %CurrentItem.Length%, which did not work because it's not a string variable. And I tried a variable of "%CurrentItem.['Name'].Length%" which gives me a syntax error. I also tried "%CurrentItem.['Name']%.Length" which gave a syntax error.
Ok this condition seems to be working: "%CurrentItem['Name']% IsBlank" then exit and will not get Employee Numbers for names that are blank.
I wish we could prints these flows out or send the to a text file so I could make sure I have the right code. In your video it's hard to see your Flow as I have 3 windows open just to learn this Flow.
Thanks for your feedback, I'm going to see how I can make it easier to follow along
Power Automate doesn't support zoom in or zoom out at this point.
In uipath I tried extracting data from different websites but how to store all the website data in one Excel file, If I do it is only storing last website data not extracting all the website data.... could you please explain about this.
Please refer to this video if you want to learn how to extract and store data with UiPath: ruclips.net/video/2ron0Y8Kk-o/видео.html
If UiPath is only storing the latest data, it's possible that you haven't enabled the "append" checkbox in the "write DataTable to Excel" activity for example
Thank you so much
hi Sir...its not turning out to be what you have shown in the video.Most of the Variable shown in videos are different...... for example in the video it showed to use %CurrentItem% but in actual its =CurrentItem and also in the video it showed %CurrentItem['Name']% working but it isn't in reality nor even =CurrentItem['Name'] is working.
Well...... your efforts in the tutorial is very good but am unable to work
Hi, which country / language setting are you using?
Please refer to the official Microsoft documentation in case you have doubt about the notation: learn.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation
As you can see the format is the same as in the video
@@TomsTechAcademy ...hello....appreciate your reply. Am from India and using English as my language
Something is wrong. First of all, upon reaching an empty row, it doesn't end the loop, goes on for almost three times more. Secondly, upon completion, excel file get corrupted.
Hi, with regards to the first challenge; if Power Automate Desktop is looping though empty rows, you can add an "if" condition in the loop and check whether the content of a column is empty. If so, use a "break" activity to stop the loop. Good luck!