Power Automate Desktop is the lesserknown cousin to Power Automate Cloud. As of 2023, it's free with the latest version of Windows so you may already have it installed! You can use it with a free Microsoft account OR with an existing M365 subscription.

In this video, we go through how to extract and parse specific values and metadata from PDFs by looking for words "next to" our values and send them to an Excel sheet. This is a beginnerlevel video, though it helps to be familiar with the concept of regular expressions for an easy intro into robotic process automation (RPA).

This technique can be particularly useful for legal and finance groups, who have a tendency to get filled PDFs routinely and then need to organize them!

0:00 Demo
2:00 Configure the Excel template
2:49 Power Automate: Get files in folder
4:42 Loop through files and extract text
6:24 Parse text using regular expressions
9:00 Split text to isolate your values
10:44 Send to Excel