Unanswered

.zip Isn't a Valid Archive

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm receiving this error when using the Unzip files flow in PAD. I've confirmed the archive and destination paths are correct, the password is correct, and the .zip file is not corrupted nor is it a large file. I have used this flow structure with two other flows and they work without issue. The structure is Wait for file -> Unzip files

Below are the details of the error. Any help is greatly appreciated.

Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: 'C:\Users\AC03372\OneDrive - Alberta Central\Mellon Reports (.zip)\Custody Valuation - Alberta Central.zip' isn't a valid zip archive or a parameter isn't set
at Microsoft.Flow.RPA.Desktop.Modules.Compression.Actions.UnzipFiles.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Categories:

Power Automate Desktop

All responses (18)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Is Mellon Reports also a .zip folder?

The other option would be to build the command line for the same thing and have PAD try to run the command line.
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Since you are accessing a OneDrive file is there a possibility that when PAD is trying to unzip the file it is not synced properly?, or the copy of the file is "online-only"?

Which icon do you see?

See it when PAD is about to unzip the file.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your response. Mellon Reports (.zip) is not a .zip folder. I just named it that so I know that's where the zipped files are being downloaded to. The files are then unzipped and pasted to a separate folder (also called Mellon Reports, also not a .zip folder)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reponse. All files are showing the light green check (second from top on your list).
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have the ability to download 7zip?

If so, they have a one-line command line option for unzipping files even with passwords. It may work for whatever reason when PAD can't.

Good luck!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, but I want the flow to work. As mentioned, the other two flows (with nearly identical code) work flawlessly. This one should as well.
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous is it possible for you copy part of your code here so we could take a look and test?
I do a lot of archiving (zip + password) and all my flows have no issues with that.

If you share your actual code I will try to replicate on my machine

//edit
Those other flows where it does work - you say "nearly identical" - what are the exact differences between working and not working code?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Momlo. I've attached snippets of the flows.

The only differences in the code are the reference file, and the export path of the unzipped file.

Flow that doesn't work

Flow that works
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, can you copy actions from PAD and paste here so we get actual PAD code?
You can replace the sensitive information with some dummy text (although perhaps some characters in the text are causing the issue?)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. Is the below the PAD code? I noticed there's no Peek Code option in PAD, so I copied the actions and pasted into Notepad.

Also, I don't think there are any issues with the characters in any of the strings as I selected the file and folder from the explorer.

WAIT (File.WaitForFile.Created File: $'''C:\\Users\\AC03372\\OneDrive - DUMMYTEXT\\Mellon Reports (.zip)\\Custody Valuation - DUMMYTEXT.zip''')
Compression.UnzipFiles ArchivePath: $'''C:\\Users\\AC03372\\OneDrive - DUMMYTEXT\\Mellon Reports (.zip)\\Custody Valuation - DUMMYTEXT.zip''' DestinationFolder: $'''O:\\Mid Office\\Compliance & Liquidity Risk\\2. Daily Exception Checks\\Mellon Reports\\Custody Valuation''' Password: P'AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALIKP2HkjvkmpWzfCdu2GMwQAAAACAAAAAAADZgAAwAAAABAAAACDPI6jU/WkIrSSkK1KdTW+AAAAAASAAACgAAAAEAAAADXP2bI+Yr/N9OFWa8ANV3EQAAAAKa695gcSzUHcokj7pfQ63RQAAABu9tXzTQvJcpyR7wkdO8lg+IpBzQ=='
File.Delete Files: $'''C:\\Users\\AC03372\\OneDrive - DUMMYTEXT\\Mellon Reports (.zip)\\Custody Valuation - DUMMYTEXT.zip'''