Skip to main content
Community site session details

Community site session details

Session Id : 1OpPXQ7g7u6AwvTPpuUnkp
Power Automate - Power Automate Desktop
Unanswered

Saving files to folder created during flow

Like (0) ShareShare
ReportReport
Posted on 11 Aug 2023 20:47:23 by 7

Hello. I am new to Power Automate Desktop and trying to figure out how to save a file to a specific folder that was created at the beginning of my flow.

The flow creates a folder with the today's date then it creates three sub folders. It then goes to a powerbi url, runs and downloads the data set. I need it to be saved into the sub folder created previously in the flow.

I thought I could just call the flow variable and follow that with a \filename.xlsx but the flow variable doesn't write to the field, so it errors out.

Any help is greatly appreciated. thank you.

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on 17 Aug 2023 at 04:15:38
    Re: Saving files to folder created during flow

    Have you tried writing %Prod1Folder.FullName%\PBI_Prod1.xlsx into your Populate text field in window action?

    Also, can you try right-clicking the %Prod1Folder% variable in the variables list on the right side of the PAD designer screen and clicking "Find usage" to see where the variable is used? Perhaps you were overwriting it somewhere, or maybe not really storing the folder there?

    -------------------------------------------------------------------------
    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.

     

  • Serafin54 Profile Picture
    7 on 16 Aug 2023 at 20:53:04
    Re: Saving files to folder created during flow

    So I completely figured it was a "me" issue but then I rebuilt the flow but using Edge instead of Chrome and it works without fail. The Edge Save As window will accept the value of the variable whereas the Chrome window in this example with just fill in the field with "\PBI_Prod1.xlsx".

    While Edge does have some quirks I needed to bypass (such as the UI Element window for the Save As Download dialog not recognizing the UI Button but that was fixed through the elements screen), I am at least able to save the file to my folder now. I am curious why this would be.

     

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on 16 Aug 2023 at 04:18:12
    Re: Saving files to folder created during flow

    You are clearly doing something wrong there. It is generally quite simple. Can you share some screenshots of your flow? Specifically - the part where the folder is created and the part where you want to use it to download the file.

  • Serafin54 Profile Picture
    7 on 15 Aug 2023 at 22:21:43
    Re: Saving files to folder created during flow

    Unfortunately this does not work since the file is being downloaded from a browser, even with a Wait until file is created step added, it just wants to move to the next step and thus fails.

  • Serafin54 Profile Picture
    7 on 15 Aug 2023 at 22:20:33
    Re: Saving files to folder created during flow

    I tried this but it did fail out on me stating the folder does not exist. I just can't understand why this would be so difficult. If you are creating a folder within a flow, you would obviously be creating a new folder each time_ and then saving to that very location each time.  I tried to create as an input variable but the text obviously was "%Folder.FullName%" instead of the variable itself. Unless I am not comprehending your suggestion. 

     

  • Kaif_Siddique Profile Picture
    2,104 Super User 2024 Season 1 on 14 Aug 2023 at 07:46:38
    Re: Saving files to folder created during flow

    Hi,

     

    Try Move file(s) or Copy file(s) action to save a file in specific folder after file download.

     

    If this does not work, share flow screenshot.

     

    Regards

    Kaif

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on 12 Aug 2023 at 03:57:18
    Re: Saving files to folder created during flow

    If you have a folder stored in %Folder% by your Create folder action you could use %Folder.FullName% to get the full path to the folder. The %Folder% variable is an object that contains some parameters, so it might not work very well when writing to a UI field. But %Folder.FullName% should work. You will clearly need to add \{FileName}.{Extension} at the end of it, as you correctly assumed.

    -------------------------------------------------------------------------
    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.

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete