Hello Community,
I'm using Power Automate Cloud and Power Automate Desktop.
How can I get the path of an Excel file that I download from a website, to "Launch Excel" in the PAD flow, with that I can get my Output Variable, to run the Power Automate Cloud flow with "Run a flow built with Power Automate for desktop" with a Virtual Machine Unattended Mode.
The file name is "exchange_suppliers_20220926_232657.xls", but the subtext "232657" always changes when downloading the file again from the website.
In the folder where I download the file is the only one there is, since I use a Virtual Machine.
To get any part of the filename or folder use-
You can use Get files from that folder and sort by the last modified (or created date) and then the 0th element of the File List will be the recently downloaded one.