Unanswered

create dynamic folders with new excel workbooks in created folders

(0) Share

Report

Posted on by Natron26

I'm trying to create multiple folders with dynamic names and inside those folders creating excel workbooks with information taken from the web.

I have figured out how to create the folders with the dynamic name but stuck on how I would create a new excel workbook with a dynamic name and save it into the current created folder.

For each row in Attached Spread sheet create a folder with the Manufacture ID and MFRNAME as folder name, then Create Excel Workbook in that folder with the file name as Manufacture ID.

First Folder Name Should Be - 955 Tesla,

Excel Workbook in that folder should be- 955

Second Folder Name Should Be - 956 ASTON MARTIN LAGONDA LIMITED

Excel Wordbook Should Be - 956

Any Help would be appreciated

Categories:

Power Automate Desktop

Sample_Data_SHARE...

I have the same question (0)

All responses (5)

Answers (2)

Michael E. Gernaey 52,972 Super User 2025 Season 2 on at

Like (0)

Report

Re: create dynamic folders with new excel workbooks in created folders

Hi @Natron26

The only way to do it, is to have a template or templates of Excel already saved. Then you would use the Get File Content (SharePoint or OneDrive) actions.

Then you would use Create File (SharePoint or OneDrive) action to essentially create your new dynamically named file.

So it sounds like
1. You use List rows in a table
2. Apply to each (on that excel table) (step 1)
3. Create your Folder
4. Get the file contents of your Template
5. Create file contents of new named file

Done

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Re: create dynamic folders with new excel workbooks in created folders

@FLMike seems to not have noticed this question is posted in the forums for Desktop flows, and has thus suggested the solution that would be required if you were doing this in Power Automate cloud flows.

The correct way to do this in PAD is to simply use Launch Excel action with a blank file and then use Save Excel action and save it as whatever name you want. Similarly to how you pass variables to the folder names, you can also pass variables to the file name in Save Excel.

-------------------------------------------------------------------------
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
Natron26 on at

Like (0)

Report

Re: create dynamic folders with new excel workbooks in created folders

Thanks for this, Once I write to a new document and save it as the name I want, how to I save it to a created folder?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Re: create dynamic folders with new excel workbooks in created folders

There is a "create folder" action.

Before saving, I would run this:

If %SaveFolder% does not exist
Create Folder %SaveFolder%

End(if)

Good luck!

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Re: create dynamic folders with new excel workbooks in created folders

When you create a folder using Create folder, you will have a variable called %NewFolder% (this is the default name, assuming you did not change it) that stores the new folder. You can use that in the Save Excel action to save it in the new folder by following the syntax like this: %NewFolder%\%FileName% (assuming you have the file name in the %FileName% variable).

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