Skip to main content
Community site session details

Community site session details

Session Id : wPaWL31FQFljRDvfJz7H+b
Power Automate - General Discussion
Unanswered

How to use "current folder" as destination folder for automation

Like (0) ShareShare
ReportReport
Posted on 24 Mar 2022 23:37:07 by

Pretty new user here. My team has a repetitive task that needs automating. 

 

We have 500 clients. Each client has a separate folder. Ever year, user must create a copy of this excel file template into the client folder. This is very tedious. I'm trying to create a button that will just copy the excel file to the current open folder. 

 

This is what I have so far. How do I get this flow to copy to the current open folder instead of the "shared document" directory? Thanks for your help

 

battmem_1-1648164888648.png

 

 

Categories:
  • manuelstgomes Profile Picture
    6,625 on 27 Oct 2022 at 14:56:58
    Re: How to use "current folder" as destination folder for automation

    Hi,

    There's a way to get all the folders in bulk and then copy the files to those folders. I wrote all the details here:

    https://manueltgomes.com/microsoft/powerautomate/how-to-copy-the-same-file-into-multiple-folders/

     

    Is this what you need?

    Cheers
    Manuel

    ------------------------------------------------------------------
    If I have answered your question, please mark it as "Accept as Solution." It will help other members find the solution faster. If you like my response, please give it a Thumbs Up. ?
    Otherwise, reply to it, and the community will do its best to help you.

  • jnernst Profile Picture
    166 on 29 Mar 2022 at 19:33:58
    Re: How to use "current folder" as destination folder for automation

    I ran into this issue recently so I could pipeline some info into a PowerShell script. and couldn't find a "perfect" solution... I ended up sending it to a SharePoint document folder and had OneDrive fetch it. That way it could be manipulated locally.

     

    Let me know if that applies in this situation.

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete