Hi @AndreRadtkeKIT
Quite a fun one this. I have a folder call ZIPs on my OneDrive and if I drop a zip into it, it will extract, delete and then rename the files in a new folder called ZIPs/Renamed. I have included a Copy/Paste solution for you below. You can copy and paste this into your Cloud Flow - all you need is the when file is created in One Drive trigger and update the Compose Action with the name of your Folder for Zips that needs monitored (first compose) and also List Files in Folder Path as it needs a folder ID. Make sure you create a Renamed folder too.
The solution looks like follows:
Which will be horrible to look at as it is a large solution, but copy this to your clipboard, click on add action and "My Clipboard" and paste and select the solution to import.
{"id":"5cd58a61-043a-49fa-b09a-69a3-65696bea","brandColor":"#8C3900","connectionReferences":{"shared_onedriveforbusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness/connections/shared-onedriveforbu-5a107753-9d6f-4fbf-957e-72c6-987acc35"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"SolutionByDamoBird365-UnzipAndRenameFilesWhenZipCreatedInOneDrive","operationDefinition":{"type":"Scope","actions":{"RootFolderPathOneDrive(PleaseUpdatePath)":{"type":"Compose","inputs":"/ZIPs","runAfter":{}},"Condition":{"type":"If","expression":{"contains":["@triggerOutputs()?['headers/x-ms-file-name']",".zip"]},"actions":{"Extract_archive_to_folder":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_onedriveforbusiness","operationId":"ExtractFolderV2","apiId":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness"},"parameters":{"source":"@{outputs('RootFolderPathOneDrive(PleaseUpdatePath)')}/@{triggerOutputs()?['headers/x-ms-file-name']}","destination":"@outputs('RootFolderPathOneDrive(PleaseUpdatePath)')","overwrite":true},"authentication":"@parameters('$authentication')"},"runAfter":{}},"Delete_file":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_onedriveforbusiness","operationId":"DeleteFile","apiId":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness"},"parameters":{"id":"@triggerOutputs()?['headers/x-ms-file-id']"},"authentication":"@parameters('$authentication')"},"runAfter":{"Extract_archive_to_folder":["Succeeded"]}},"Apply_to_each":{"type":"Foreach","foreach":"@outputs('List_files_in_folder_(PleaseChoosePathDynamically)')?['body/value']","actions":{"IsFolder":{"type":"If","expression":{"equals":["@items('Apply_to_each')?['IsFolder']",false]},"actions":{"Move_or_rename_a_file":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_onedriveforbusiness","operationId":"MoveFile","apiId":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness"},"parameters":{"id":"@items('Apply_to_each')?['Id']","destination":"@{outputs('RootFolderPathOneDrive(PleaseUpdatePath)')}/Renamed/@{formatdatetime(utcnow(), 'yyyy-MM-dd-hh-mm-ss')}-@{items('Apply_to_each')?['Name']}","overwrite":true},"authentication":"@parameters('$authentication')"},"runAfter":{}}},"runAfter":{}}},"runAfter":{"List_files_in_folder_(PleaseChoosePathDynamically)":["Succeeded"]}},"List_files_in_folder_(PleaseChoosePathDynamically)":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_onedriveforbusiness","operationId":"ListFolderV2","apiId":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness"},"parameters":{"id":"b!BOIVsACSM02nAvrKA5sQqce2eGDhytpJrD6Ky1g1xl_-qoaIOl6yRo2252_HSDPt.01SRF3RDR3SFSATUXT5RCJKR4VMGQFQFCN"},"authentication":"@parameters('$authentication')"},"runAfter":{"Delete_file":["Succeeded"]},"metadata":{"b!BOIVsACSM02nAvrKA5sQqce2eGDhytpJrD6Ky1g1xl_-qoaIOl6yRo2252_HSDPt.01SRF3RDR3SFSATUXT5RCJKR4VMGQFQFCN":"/ZIPs"}}},"runAfter":{"JustForDemoTheFolderIDForListFilesButItDoesntAcceptIt":["Succeeded"]}},"JustForDemoTheFolderIDForListFilesButItDoesntAcceptIt":{"type":"Compose","inputs":"@substring(triggerOutputs()?['headers/location'],ADD(indexof(triggerOutputs()?['headers/location'],'folderId='),9),sub(length(triggerOutputs()?['headers/location']),indexof(triggerOutputs()?['headers/location'],'&includeSubfolders')))","runAfter":{"RootFolderPathOneDrive(PleaseUpdatePath)":["Succeeded"]}}},"runAfter":{}}}
Give it a go and let me know.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
