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
Super User II
Super User II

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,457)