Skip to main content

Notifications

Power Automate - Power Automate Desktop
Answered

FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

(0) ShareShare
ReportReport
Posted on by 288

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.

  • Verified answer
    VJR Profile Picture
    VJR 7,635 on at
    Re: FILE PATH TO EXECUTE FLOW WITH VIRTUAL MACHINE UNATTENDED

    To get any part of the filename or folder use-

     

    VJR_0-1664334274705.png

     

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    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?

     

    fgonzalez515_0-1664326935400.png

     

    fgonzalez515_1-1664326960399.png

     

     

  • VJR Profile Picture
    VJR 7,635 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard