Recently, there's a new action in Microsoft Power Automate for Desktop called "Extract tables from PDF". That's right—now you have an option to extract the tables from PDFs directly with an action, instead of having to go through complicated text manipulation to do it.
If you're interested, you can check out the text manipulation method here: https://www.youtube.com/playlist?list=PLtS0QJFKl_DZa30UIUeMmcQ0-vR5areKR
Is it as good as it sounds? Check out our video and see how you can leverage this new action to work better and faster.
00:00 Introduction
00:30 Extract table from PDF action
00:48 Output of the extract table from PDF action
02:44 Preparing flow to write extracted table data into Excel into different worksheet
07:10 Writing column names of extracted table into Excel
12:35 Writing all extracted table data into Excel
14:00 Suggested enhancements
Related Microsoft Power Automate for Desktop videos:
- Loop actions: https://youtu.be/KPpHBVdMaFs
- Conditionals: https://youtu.be/U12eo9DRYdE
- Excel automation basics: https://youtu.be/XmRXjpMb2Rg
- Extracting PDF invoices using text manipulation: https://youtu.be/bhIclwHxSiY
Keep in touch!
Website https://mspowerautomate.com/
Twitter https://twitter.com/MsAutomate
Facebook https://www.facebook.com/MS-Power-Automate-105388391663527
LinkedIn https://www.linkedin.com/in/power-automate/
#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate
