cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RajeshCh
Frequent Visitor

Extract Pdf Specific Data To Excel In power automate desktop

Extract Pdf Specific Data To Excel In power automate desktop
consider i have 100 pdfs i need to extract invoice number, bill address ,total amount for each pdf to excel sheet row by row.

please help me ASAP

4 REPLIES 4
miketran13
Solution Specialist
Solution Specialist

Hi 

 

In your cases, if you just want to extract data from PDF with a specific metadata likes invoice number, bill address,... and store it into a file, then you just need to create a Cloud Flow that includes AI Builder form action. So, you can extract the metadata you need and store it somewhere on the cloud. 

 

If you need to extract data from PDF then you have to perform other actions on the window likes update SAP, Salesforce, or other applications then you should use Power Automate Desktop. But, to do that on Power Automate Desktop, it is a bit more difficult and complicated since you have to use an OCR service on Power Automate Desktop, righ now there are actions for OCR with Tesseract OCR, Google, Microsoft, IBM available on Power Automate Desktop

 

Thanks and hope it can help you. 

Mike

---------------------------------

Did I answer your question? Please consider to Mark my post as a solution! to guide others

 

 

Thank you for  your information.

Great answer. But if you consider other RPA tools like UI path, i observed this task is very simple.

My expectation compare to other tools Microsoft should provide simplified basic solution for many scenarios.

 

 

JoeF-MSFT
Power Apps
Power Apps

Hi @RajeshCh,

 

Building on the answer from @miketran13, the following Microsoft Learn module will teach you how you can use AI Builder to extract data from invoices and store the extracted results in an Excel file: Get started with invoice processing in AI Builder - Learn | Microsoft Docs

wintechchen
New Member

Hi,

I am able to use AI Builder to create a Form processing model to extract PDF invoice data and then to Excel. My challenge is that financial invoice is created in a horizontal direction, not like purchase order invoice in vertical direction. Also the invoice often might not have all items on the list. That makes hard to know which column name is at position 1.  Any idea to handle that situation?

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (97,060)