Get data from PDFs and send to EXCEL with Power Automate Desktop!
This video demonstrates how to use Power Automate Desktop to extract data from PDFs and send it to an Excel sheet. It is a beginner-level tutorial that covers the process of extracting specific values and metadata from PDFs using regular expressions. This technique can be helpful for legal and finance groups that frequently receive filled PDFs and need to organize them. The video includes a demo and step-by-step instructions on configuring the Excel template, getting files in a folder, extracting text, parsing text using regular expressions, splitting text to isolate values, and sending them to Excel. The video timestamps are provided for easy navigation.
Video 18m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time