Open downloaded file from edge

(0) Share

Report

Posted on by Shawn0529

Hi there, I need some help in below challenge.

What I need to do repeatedly is download from a website, by selecting date on a calendar , and press a bottom.

Then downloads started, I set a 10s waiting time, then the files(*.CSV) will be downloaded to a target folder.

Then I need the flow to open the downloaded file and save as *.xls.

The method to get the downloaded file is by through 1. get file list and 2. open list[0].

It worked most time. However sometimes the files may be too big and it need more time to download, so when the flow run the get the file list line, the download is not ready, so it returns an empty one, there for it erro when open list[0] .

1. Therefore is there an easier way to find the downloaded file and open it, that would have less risk to error?

2. I follow the error handling guidance, and added an error handling at the action of open list[0], hoping the flow could try again the action of get file list, however it seems nothing triggered. Not sure any body met it this before?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Use wait file file activity then follow the next steps or
you can use wait for window content and you can give the reference of the window appears on changing after dowloaded
or you can check if the file is downloaded or not by checking the path by using if activity then process

Hope this helps
Usha.

Was this reply helpful? Yes No
Shawn0529 7 on at

Like (0)

Report
Copy link

Link copied!

Hi Usha, thanks for the suggestion
As the name of file downloaded is random, I could not use wait for content.
You mind sharing an example for the folder path method? I am not quite sure how to write conditional statements for the folders.

Was this reply helpful? Yes No
Verified answer

UshaJyothiKasibhotla 225 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Shawn0529
You can do as following
use get files from folder
and then get count as count variable
if you get the count as count +1 then proceed next action
otherwise put wait

Hope this helps
Usha.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Instead of using the default Downloads directory, adjust the settings of MS Edge so that it would always ask you where to download the files to. Then use UI automation to pass the file path (including the folder and the name of the file) to the File name field of the "Save As" window. This way you will always know where the file gets saved and you will also be able to set the file name yourself. You can then use Wait for file to wait for the download to complete if the file is large.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Shawn0529 7 on at

Like (0)

Report
Copy link

Link copied!

Hi Usha, Although I didn't directly use your solution, you opened up my mind and I ended up using "isempty" to determine if the download had been completed in the target folder, and I will request to clear the folder at the end of each loop. Thank you so much.

Was this reply helpful? Yes No