@EdiSM
It's guaranteed to work; I've specifically designed the bot to function this way. Don't worry; just give it a try and inform me of the results.
You can't maintain all the Excel files with the same name, right. That's why I've trimmed the first few characters of each Excel file name and added a counter as a suffix. That's why it's displaying like that in the output.
Code:
Folder.GetFiles Folder: $'''C:\\Boot\\xslx\\''' FileFilter: $'''*zip''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
SET Counter TO 1
LOOP FOREACH CurrentItem IN Files
Compression.UnzipFiles ArchivePath: CurrentItem.FullName DestinationFolder: $'''C:\\Boot\\xslx\\Unzip\\%Counter%'''
SET Counter TO Counter + 1
END
Folder.GetFiles Folder: $'''C:\\Boot\\xslx\\Unzip''' FileFilter: $'''*xlsx''' IncludeSubfolders: True FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
SET Counter TO 1
LOOP FOREACH CurrentItem IN Files
Text.SplitText.SplitWithDelimiter Text: CurrentItem.Name CustomDelimiter: $'''_''' IsRegEx: False Result=> TextList
File.RenameFiles.Rename Files: CurrentItem.FullName NewName: $'''%TextList[0]%_%Counter%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
File.Move Files: RenamedFiles Destination: $'''C:\\Boot\\xslx\\New folder''' IfFileExists: File.IfExists.DoNothing MovedFiles=> MovedFiles
SET Counter TO Counter + 1
END
How to copy/paste the above code into your power automate desktop?
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
