Answered

Renaming Multiple PDF files based

(0) Share

Report

Posted on by PKDonna

I am brand new to POWER AUTOMATE and excited to give it a try!

I have a folder of PDF files and they all have a system name, I want to rename all 167 pdf files based on the Name field inside the pdf. Do I have to open the PDF, copy the name and then save as or is there an easier process to rename multiple files? I did create an AI form processor that identifies the name I need from the PDF file, how can I implement that?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (14)

Answers (1)

UK_Mike on at

Like (0)

Report
Copy link

Link copied!

No you dont have to open each file.
Just extract the text from the pdf, look at the output, if the name field is always in the same position, easy peasy, if not I would recommend regex.

Was this reply helpful? Yes No
PKDonna 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response. Yes the name is always in the same location. When I add extract Text from PDF, I do not see where it asks me what to extract...how does it know what field I need from the PDF? how do I look at the output?

This is what I have so far

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Its in the %extractedpdftext% on the variable pane to the right, double click to view output...

Was this reply helpful? Yes No
PKDonna 22 on at

Like (0)

Report
Copy link

Link copied!

Okay.. I need more help than that. I need it to extract just a certain field (Name) and use that to rename the PDF file. As I said, I am BRAND new and this is too simplistic of an answer. Can you recommend a tutorial that may be able to help?

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

This

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Ps... If you have the same name twice, you cant have 2 exact filenames in the same folder, will need an invoice number or something else to distinguish...

Was this reply helpful? Yes No
PKDonna 22 on at

Like (0)

Report
Copy link

Link copied!

I am not pulling information from invoices... Thanks for the information, but I will continue searching for online help... I don't understand

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

You quite clearly said the info you required was inside the pdf ?
I and everyone else are here to help...
My output from double clicking on the variable I told you about earlier...

Was this reply helpful? Yes No
PKDonna 22 on at

Like (0)

Report
Copy link

Link copied!

Yes, I appreciate your patience. So from the extracted PDF Text I need information that is on line 134 and that is the data I need to rename the file. How do I pull that name on line 134 into a variable and use it to rename my file?

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Split %ExtractedPDFText% like below, the output will be %TextList% , the info you require will be on the line stated within this variable.

Was this reply helpful? Yes No