cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dil21
Regular Visitor

How to Extract text from PDF file by folder?

Hi Team, 

 

I am pretty new to this power automation world & not sure this is the right platform to ask this question. 

 

I am trying to build a RPA for our outbound orders team. 

 

> we receive multiple orders in pdf format form our customers 

> then we copy paste around 10 fields from these pdf files to existing excel sheet one by one. 


I would like to know is there a way I can extract the text form multiple pdf files instead of converting a one file. 


Example - Get all the pdf files from one folder and extract the text from those pdf files. 

 

Is there a way I can automate this by power automation? 

 

Thank you

4 REPLIES 4
fraenK
Memorable Member
Memorable Member

Power Automate Desktop can extract text from PDF but this would only work if the PDF files have all the same layout and text elements could be extracted using regular expressions.

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/pdf#extracttextfromp...

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#parsetext

 

If the PDF files have different layouts then you'll need to use the AI Builder within a cloud flow:

https://docs.microsoft.com/en-us/power-automate/use-ai-builder

https://docs.microsoft.com/en-us/ai-builder/model-types

 

There are also prebuilt 3rd party solutions dedicated for this specific type like: https://workist.com/en/ 

Dil21
Regular Visitor

Thanks for that Can I convert multiple files in word by using power desktop app instead  of doing it one by one. 

How can I convert the files in doc word? 

Thank you

fraenK
Memorable Member
Memorable Member

You can open (some) PDFs directly with Word but this won't help you much. 😉

Dil21
Regular Visitor

Yes, that's not gone help me as I am trying to build a RPA for this process. 

 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (43,293)