web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Simple - Copy, Paste, ...
Power Automate
Suggested Answer

Simple - Copy, Paste, Wait, Select mp3, Download, do again for another 295 times.

(0) ShareShare
ReportReport
Posted on by
Hello everyone,

I'm new to power automate and need assistance to do a very, yet time consuming task. Hoping someone who is skilled enough can please help me. Below are the steps.
Please let me know if you require additional information. I did try the record/capture thingy, but it's not giving the outcome expected.

1 Go to excel file “EDIT1”
2 Start at Tab “Sheet1”, cell “A2”, copy cell contents
3 Paste URL line in MS Edge
4 Wait for page to load, about 30 seconds
5 website “File Format:” select “Mp3” from drop down menu
6 Click download button
7 Wait about 20 seconds,
8 Look, Go back to step1, BUT with step 2, go next cell down, which is A3,
9 Set loop counter to 295
 
I have the same question (0)
  • Suggested answer
    eetuRobo Profile Picture
    4,204 Super User 2025 Season 2 on at
    I recommend you use the Recorder as you did but then just edit the parts that don't work as expected.
    So you need to add the wait periods since the recorder doesn't add those or atleast the amount you want to wait. 

    The recorder most likely gives you of hard coded "Wait" -actions for about 2 seconds but you should change those to "Wait for web page content" -actions. And after clicking download button use "Wait for file" -action instead if you know the name that the file will be downloaded. If you dont know the name of the file then just the hard coded 20s

    something like this:


    Create the flow as far as you can and ask for guidance on the steps that you find difficulty with.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard