File download Issue

Like (0) Share

Report

Posted on 15 Mar 2025 00:17:52 by DN1

Hello Everyone, I am using Power Automate Desktop (PAD) to download files from a website that contains 20,000 files. However, I only need to download four specific files: 1Q12024.CSV, 1Q22024.CSV, 1Q32024.CSV, and 1Q42024.CSV (quarterly files).

I have created the following flow, but it is not downloading the files as expected. I’m not sure what mistake I made. Any help would be greatly appreciated. Thank you!

Categories:

Licensing

Process Advisor

All responses (1)

Answers (0)

Suggested answer

eetuRobo 3,032 Super User 2025 Season 1 on 15 Mar 2025 at 05:30:21

Like (0)

Report

File download Issue

So the flow runs successfully but never downloads the files? I suggest try using breakpoints in the flow to see what the flow is doing and why it never downloads the files. So put debug breakpoint to Increase variable action and check the why it never goes into the download if condition.

Maybe you need to move the Increase variable inside the If condition so that it increases only when the current file is 1Q%Number%2024.csv. Otherwise it will increase even if there is some other files before it which the flow won't download.

Or maybe you want only go through first 4 files of the current item. But then you need to set the Number variable back to 0 outside the loop condition.

Since your %Filenamelist% contains like 20k items I would try to use Filter data table -action to filter it down so you don't need do the for each loop 20k times + the loop condition in side it. So maybe filter it starting with '1Q' or end with '2024.csv'

Like so: