Answered

Unable to retrieve and rename PDF file, based on excel data

(0) Share

Report

Posted on by Tim19943

I'm trying to create a simple flow for renaming my PDF files based on excel data. But for some reason the output of my get file or rename file is empty. I don't see why. the output from my "read from excel" is fine. what am i doing wrong?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Does the "OldID" match the file name of the PDF file? Does it also include the extension (.pdf)? If it matches the name, but not the extension, you need to filter for %OldID%.pdf or %OldID%.*

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Tim19943 56 on at

Like (1)

Report
Copy link

Link copied!

i feel so dumb. it was really that easy! thank you!

Was this reply helpful? Yes No
elena123 7 on at

Like (0)

Report
Copy link

Link copied!

Hello 🙂 I am struggling with exactly this topic, how to rename files based on excel data. Could maybe someone give me advice?
I am trying to rename files with data from an excel sheet that is linked to an individual number on the PDF file. This number is also present in the excel file.

I'd be very excited if soemone could help 😄

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

read excel to a variable, but it’s in table format, so you have to get the data out such as

for each %exceldata%
Set %Number% to %CurrentItem[‘Number’]%
get files %Number%*.pdf (if the pdf starts with the number; move the star in front of the pdf begins with the number. )

good luck.

Was this reply helpful? Yes No