Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Rename all files in a SP Library Based on Excel Column Values

(0) ShareShare
ReportReport
Posted on by

I have 19k files in a library in SP that have generic names (068Do000005QxlaIAC for example), and I have an excel file with a table that has these exact same names in column A, and the actual file name in column B.

 

How would I go about renaming all these files based on data from the excel table?

 

PatrickMcLeanGL_0-1711658822745.png

 

PatrickMcLeanGL_1-1711658895206.png

 

  • Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: Rename all files in a SP Library Based on Excel Column Values

    Gotcha.

     

    Okay, so, if we're making them all .pdf to start, I'd add that to the Excel file. 

     

    Here's what my Excel file looked like:

    Rhiassuring_2-1711667800297.png

     

    And here's the flow:

     

     

    Rhiassuring_0-1711667730035.pngRhiassuring_1-1711667750081.png

     

    Let me know if you have any issues.

     

    One thing to note:

     

    If you have other metadata that you want to carry over in other columns, you'll need to do some other steps before you delete. Let me know.

     

    Also keep in mind that when you transition them all to PDF, they won't open if they aren't PDFs. I'm streaming right now and we're trying to figure out how to determine a file type without an extension using PA but haven't gotten there yet.....

     

    R

     

  • Re: Rename all files in a SP Library Based on Excel Column Values

    Well that is part of the problem, they are all either jpg, pdf, or word and I have no way of knowing, so to start I was going to make them all pdf to see what opens and what doesn't and then go from there.

     

    I want the filename changed.

  • Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: Rename all files in a SP Library Based on Excel Column Values

    Hi there, 

     

    First off, I want to be clear that NAME and TITLE are different. NAME is the filename (includes extension) and Title is the actual display title of the document. Right now, I don't see an extension in NAME, which is an issue! What is the file type? Do these actually open?

     

    Do you actually want to rename the NAME (filename), OR, do you want to ADD (or update, if it's already there) the TITLE? In your view of SharePoint, modify it, and add "Title" to the view. It might be auto-populated with the NAME.

     

    Let me know, and I'll do an example for you 🙂 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard