that works for this particular download, but the next download (e.g. I added the action "Click on UI element in window" and saved the current file name
And there is exactly my challenge: How do I rename a file whose name changes from month to month (or rather depending on the date when I download the file)? in order that the query in my xls-report works, I need to rename the download to a standardized name, e.g. "download_20220927.xlsx" - part 1 "download_" never changes, part II "20220927" changes always according to the current date when I retrieve the data the download file name consists of two parts, e.g.
for that, I have to download some data (also xls) from a website (which I have automated via Power Automate) You can use the “Rename File(s)” action from Power Automate to change the name of the file once it’s moved or copied to the final destination.- I am maintaining a xls-report that needs to be updated with the latest data every month Note that you can copy of move files, depending on your specific process. We’ll add a copy file action (you can also use a move file action with the same logic). We would need to move this file from its current location (the default downloads folder) to the final destination. So if we access the VERY FIRST file of the list, we’ll be getting the file we just downloaded. Now that we have the Files list, since we ordered in Ascending mode, it’s going to have the most recent file at the top. Important: depending how big is your file and how long it may take to fully download, add a small delay before getting the list of files This will make the most recent files to show first. When a file downloads, it will go to the folder you defined in the Browser settings.Ĭlick on the advanced options and then Select Sort By “Creation Time”, and then Enable Descending. But, don’t you worry! There is still a great workaround for this.įirst, make sure to disable the “ask” option and define a default location for your files. Above set up might not always work, sometimes the window that asks for the file name has a dynamic title and this can be a HUGE issue.
0 kommentar(er)
