Unanswered

Saving files to folder created during flow

(0) Share

Report

Posted on by Serafin54

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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Serafin54 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Serafin54 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Serafin54 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No