Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QrVYNjkVF704rVmtYhBoez
Power Automate - Power Automate Desktop
Suggested answer

File download Issue

Like (0) ShareShare
ReportReport
Posted on 15 Mar 2025 00:17:52 by 76

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!

 

  • Suggested answer
    eetuRobo Profile Picture
    3,032 Super User 2025 Season 1 on 15 Mar 2025 at 05:30:21
    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:


     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started