Hi @Anonymous34 !
You can try this simple flow.
Initialize an input variable which you can trigger from outside and you just have to type the project number in that field.
Type your project number here to run:
So what this flow actually does is that, I launch an empty excel file (or maybe an already existing one but you can modify it accordingly), I do some processing for the excel file noted in the comments. Then I simply list out all the folders in that main directory. A list of folders will be produced. Iterate through each using for each loop. Check the condition if the name of the folder is containing the input variable value. If yes, get the subfolders within this project folder, I guess its always going to be "ExceldocumentProject". So you can index it to just the first folder given by index 0. Then save the excel file as:
Then close the excel as the "save document" and exit the loop because its doing for one excel file and once it got the folder, no need to keep iterating over and over.
Additionally, I added a boolean variable to keep check incase if you don't get the project folder. So if you get the folder, make it true and exit from the loop.
But if not found, i.e. it is still false, save the excel file as the same pic above and close the excel as the "save document".
My project folders and in each of them already there is a subfolder named "":
First round (incase if project folder doesn't exist):
Input:
Output:
Second Round (the case if project folder already and subfolder already exists and just save it there):
Input:
Output:
Third Round (the case if project folder already exists but its subfolder doesn't exist and just save it there):
I guess you got the point here as well.
Code (just copy-paste this code into your flow) :
SET MainFolderPath TO $'''C:\\Users\\Username\\Desktop\\ProjectFolders'''
SET boolFoundFolder TO False
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance
# ##########################################################################################
# Add the process part for excel here
# ##########################################################################################
Folder.GetSubfolders Folder: MainFolderPath FolderFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Subfolders=> Folders
LOOP FOREACH Folder IN Folders
IF Contains(Folder.Name, varProjNumber, True) THEN
Folder.GetSubfolders Folder: Folder FolderFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Subfolders=> SubFolders
IF IsEmpty(SubFolders) THEN
Folder.Create FolderPath: Folder FolderName: $'''ExceldocumentProject''' Folder=> NewSubFolder
Excel.SaveExcel.SaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: $'''%NewSubFolder%\\%varProjNumber%'''
ELSE
Excel.SaveExcel.SaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: $'''%SubFolders[0]%\\%varProjNumber%'''
END
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
SET boolFoundFolder TO True
EXIT LOOP
ELSE
NEXT LOOP
END
END
IF boolFoundFolder = False THEN
Folder.Create FolderPath: MainFolderPath FolderName: $'''%varProjNumber%_ProjectFiles''' Folder=> NewFolder
Folder.Create FolderPath: NewFolder FolderName: $'''ExceldocumentProject''' Folder=> NewSubFolder
Excel.SaveExcel.SaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: $'''%NewSubFolder%\\%varProjNumber%'''
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
END
I hope this helps.
