Skip to main content

Notifications

Community site session details

Community site session details

Session Id : sTEdOqAA9igfM5nwqIBFaR
Power Automate - Power Automate Desktop
Unanswered

Batch rename files according to values in Excel worksheet

Like (0) ShareShare
ReportReport
Posted on 17 Nov 2022 23:13:08 by 7

I have a flow that is meant to batch-rename a set of files according to the values in an Excel worksheet, with a column for the old file names and one for the new ones. The flow seems to run fine; however, the filenames do not update.

 

There are no errors, and the flow variables load correctly, so I cannot see what I'm missing.

  • VJR Profile Picture
    7,635 on 20 Nov 2022 at 03:42:58
    Re: Batch rename files according to values in Excel worksheet

    There have been users using Mac reporting about a few issues while using PAD and also the pre-requisites page shows only Windows.

     

    @Statto 

    1. What did the "Get Special Folder" show to you as illustrated above?

     

    2. Can you also try mapping the \\Mac...\Files folder to a drive label like F:\Files.. and then see if it makes any difference?

  • Rhiassuring Profile Picture
    8,688 Super User 2025 Season 1 on 19 Nov 2022 at 22:02:23
    Re: Batch rename files according to values in Excel worksheet

    Yeah, I think this particular Microsoft product might hate your Mac file location. 

    @VJR are there any posters in your community (lol, referring to the entire Power Automate Desktop community as your community) that are Mac users, that you know of? Anyone we could tag?

  • Statto Profile Picture
    7 on 18 Nov 2022 at 22:41:52
    Re: Batch rename files according to values in Excel worksheet

    Thanks for your responses, @Rhiassuring  and @VJR. However, I am still having an issue. I am using a Parallels Windows virtual machine on my MacBook, so that might have something to do with it.

     

    I've changed the file location, but to no avail. It doesn't make sense! I will just have to keep trying, I guess.

  • VJR Profile Picture
    7,635 on 18 Nov 2022 at 03:10:48
    Re: Batch rename files according to values in Excel worksheet

    Everything seems right in your Flow.

    Try getting the path of the Desktop from this action.

    If still not working, check the same from some other path. It should not be any system related path like Temp or Desktop or Documents etc. That will tell if it's a system folder path issue or something else.

     

    VJR_0-1668740918291.png

     

  • Rhiassuring Profile Picture
    8,688 Super User 2025 Season 1 on 18 Nov 2022 at 02:06:08
    Re: Batch rename files according to values in Excel worksheet

    Hi there, 

     

    So I don't know if this will be helpful or not, but, I've just done what you're doing and .. it works perfectly for me:

     

    Rhiassuring_0-1668737105677.png

     

     

    And really the only difference I can see is the filepath .. which... I'm guessing macs do differently. 

     

    Rhiassuring_1-1668737139648.png

    There's gotta be something we're missing.. hmm..

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 4 Super User 2025 Season 1

#2
KO-05050229-0 Profile Picture

KO-05050229-0 2

#2
stampcoin Profile Picture

stampcoin 2

Overall leaderboard
Loading started