Notifications
Announcements
Hi. Need help in extracting data from pdf invoices to excel. Need the following info from the invoice:
Customer ID
Customer Name
Service Period Start
Service Period End
Invoice Date
Invoice Number
Payment Due Date
Charge Description
Charge Date
Charge Quantity
Charge Amount
Thanks
Hey @Mich_Parakeet
Will is be an option for you to use a third party connector? If yes, I had used a thrid party connector to Get Data from PDF and it does an Awesome Job - https://www.aquaforest.com/blog/aquaforest-flow-connector-get-data-from-pdf-populate-into-excel
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
I don't have personal experience with AI Builder Models, but it looks like there is capability to build a model that can grab the data you need from PDFs.https://learn.microsoft.com/en-us/ai-builder/use-in-flow-overview
You can also now use this text extraction & GPT processing template to extract specific data from various documents with many different formats and/or data: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-Data-From-PDFs-and-Images-With-GPT/td-p/2201345
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 538 Super User 2025 Season 2
Tomac 405 Moderator
abm abm 252 Most Valuable Professional