FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

(0) Share

Report

Posted on by fgonzalez515

296

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.

I have the same question (0)

All responses (3)

Answers (1)

VJR 7,635 on at

Like (0)

Report

Re: FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

Hi @fgonzalez515

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.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

Hi @VJR,

When I run flow in Power Automate Cloud, it gives me this error.

How can I solve that?

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report

Re: FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

To get any part of the filename or folder use-

Was this reply helpful? Yes No