Open downloaded file from edge

[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?

[UshaJyothi20]

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.

[Shawn0529]

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.

[UshaJyothi20 · Accepted solution]

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.

[Agnius]

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.

[Shawn0529]

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.