How to pass the PL-500: Power Automate RPA Developer Associate Certification Exam

Table of Contents

Microsoft announced their new PL-500: Power Automate RPA Developer Associate Certification Exam, here is how to pass it.

Are you as excited as me about the new PL-500 certification from Microsoft?

How

This guide is a help to learn the topics required for passing the PL-500: Power Automate RPA Developer Associate Certification Exam.

I’ve created a hands-on use case for each topic and a corresponding video. Find each guide and video below in Video lessons.

Work in progress – I’m trying to create 1-2 videos each week, so we’re ready to pass the exam in late May) 🙂

Video Lessons

LessonTitleDescription
1Install and SetupInstall Power Automate Desktop and build your first robot
2VariablesThe most common variable types and how to use them
3The RecorderMake your life easier
4If and LoopLearn the most used logic operators
5ExcelAutomate the most used business application
6ApplicationsClick buttons or input data in applications
7BrowsersAny webpage can be automated
8File HandlingLearn how to handle files and create a log
9Web ScrapingThe moment we all waited for
10OutlookExtract information from Outlook emails
11RPA ChallengeAdvanced Excel and web automation
EThe Next StepsMy recommended next steps

Quiz

LessonTitleDescription
Q1QuizTest your knowledge about variables
Q2QuizTest your knowledge about the recorder
Q3QuizTest your knowledge about If and Loop
Q4QuizTest your knowledge about Excel actions
Q5QuizTest your knowledge about applications
Q6QuizTest your knowledge about automating browsers
Q7QuizTest your knowledge about file handling

Use Cases

LessonTitleDescription
1Excel and Web SearchWeb search from Excel input, write back to Excel, and handle exceptions
2VAT LookupsA well-suited RPA process
3WebscrapingHow to scrape URLs and individual items
4SelectorsComplete and win the RPA Challenge
5Advanced ExcelAdvanced Excel work (Currency/Accounting)
6Advanced Web ScrapingWeb scraping with error-handling, logging, API calls, JSON parsing and Power Automate Desktop best practices
7The Power of ChatGPT in Power Automate Desktop DevelopmentAdd AI and sentiment analysis to your flows
8PDF Extraction & Application EntryParse PDFs with Regular Expressions and type the data into an application

Questions/feedback

Do you find something hard? I’ll then be very happy if you ask me on:

Here you can also post feedback if you think I can improve on something.

Links