If I have a folder with file names and their titles in the below format (as an example)
They get renamed to Title after running the Flow
This is a vbscript approach. You can use anything else like Powershell etc.
The script used is:
Dim oAppShell, oFolder, output
Set objFso = CreateObject("Scripting.FileSystemObject")
Set oAppShell = CreateObject("Shell.Application")
varFolderPath = "%FolderPath%"
Set oFolder = oAppShell.Namespace(varFolderPath)
For Each oItem In oFolder.Items
'Check here if title is empty
'If a file with already same name exists while moving then it will throw error. Please handle accordingly
objFso.MoveFile oItem.Path, varFolderPath & oFolder.GetDetailsOf(oItem, 21) & ".mp3" '21 is to get the Title
Next
Copy paste the below code in a blank flow editor and check the outputs.
Please refer the green comments inside the vbscript.
SET FolderPath TO $'''C:\\Test\\'''
Scripting.RunVBScript VBScriptCode: $''' Dim oAppShell, oFolder, output
Set objFso = CreateObject(\"Scripting.FileSystemObject\")
Set oAppShell = CreateObject(\"Shell.Application\")
varFolderPath = \"%FolderPath%\"
Set oFolder = oAppShell.Namespace(varFolderPath)
For Each oItem In oFolder.Items
\'Check here if title is empty
\'If a file with already same name exists while moving then it will throw error. Please handle accordingly
objFso.MoveFile oItem.Path, varFolderPath & oFolder.GetDetailsOf(oItem, 21) & \".mp3\" \'21 is to get the Title
Next
''' ScriptOutput=> VBScriptOutput ScriptError=> ScriptError
Display.ShowMessageDialog.ShowMessage Message: $'''DONE''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
# [ControlRepository][PowerAutomateDesktop]
{
"ControlRepositorySymbols": [],
"ImageRepositorySymbol": {
"Name": "imgrepo",
"ImportMetadata": {},
"Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}"
}
}
