cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshleyLausing
New Member

Renaming a PDF by cross references its contents to an excel file

I'm trying to automate a process we currently have for our business.

 

We receive a lot of PDFs from clients (via email) and we then have to rename them based on their contents:

 

Current process:

- File contains a [ClientID] (this is generated by them and always stays the same)

- We cross reference that identifier with our own internal unique identifier [InternalD] (this changes based on type/date of order etc)

- Currently a user looks up the [ClientID] on a spreadhseet and therefore knows the [InternalID]

- The file is renamed to [InternalD].PDF

- The user also reads the pdf for to determine if its a full or partial order received.

- The file is renamed to [InternalID] [Full].pdf or [InternalID] [Partial].pdf 

 

So to automate it would need to :

 

- Read and pull the [ClientID] from the .PDF (this is easy to identify on the document as it follows the words "Client ID" as is always the the same format (10 digit number)

- Search the excel file to see if it can find [ClientID] [in column A)

- If it find it, it pulls the [InternalID] (from column B) and renames the file accordingly.

- If possible, it also reads the file for certain phrases (full or partial) and then appends that to the filename

 

I'm not sure if this is possible.

 

Any advise would be appreciated, thanks in advance !

 

2 REPLIES 2
CollabTechie
Responsive Resident
Responsive Resident

The parser connector or Azure cognitive services may be able to help with this one
https://docs.microsoft.com/en-us/connectors/parserr/

 

Jay-Encodian
Community Champion
Community Champion

There's a few actions in the Encodian connector which may help?

EXTRACT TEXT FROM REGIONS - There is a useful guide on the community blog: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Extract-data-from-documents-with-M...

GET PDF TEXT LAYER - https://support.encodian.com/hc/en-gb/articles/360015539373-Get-PDF-Text-Layer

HTH

Jay

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,515)