Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Copying URL from Excel to a web page

Like (0) ShareShare
ReportReport
Posted on 24 May 2023 23:15:00 by 12

I am new to Power Automate and starting to learn with my first flows.

One very important task for me is to copy a URL from a specific cell in Excel and then paste it into a specific field on a website. I will be creating quite a few flows using this basic task.

Each time Excel is accessed, the URL will be different, so I need something dynamic.

I tried using the "Record" option. However, this got me stuck with the same URL being pasted into the website each run.

I then tried to read the cell contents to create a variable. I copied the variable name %URL% into the automation step created by the screen recording, replacing the URL that was copied on my first try. For some reason, using the %URL% variable did not result in the URL being copied into the specified location.

Looking for recommendations how to solve this. Also, any recommendations on learning resources would be most appreciated.

  • wcleveland Profile Picture
    12 on 26 May 2023 at 19:44:06
    Re: Copying URL from Excel to a web page

    Koen

    Another reason I am using Desktop is I am using the desktop apps of MS office rather than the cloud versions. I poked around the PA Cloud and it looks like it uses the cloud apps, to which I am unsure how much access I have.

    Thanks,

    WC

  • wcleveland Profile Picture
    12 on 26 May 2023 at 19:21:05
    Re: Copying URL from Excel to a web page

    Koen

    Thanks so much for your reply. Any thoughts about learning resources are very welcome.

     

    I am using PowerAutomate Desktop because I am brand new to this and working up the learning curve. I was not aware the platforms had major differences in functionality and where to post questions. Since I am working through my personal account & do not have access to an institutional account, it looks like I would have some limitations in the cloud & unsure the consequences.

     

    I've copied the 2 flows below and also attached in case they are not sufficiently visible in the post. Step 1 for each flow is to attach tor running Excel file.

     

    Main Flow has what I got from the "recorder" in steps 12-15

    wcleveland_1-1685128522567.png

    Subflow 1 where I copied the "recorder" information and replaced with the %Domain% in step 15. When I try this out, nothing gets pasted into the specified box on the webpage.

    wcleveland_0-1685128318262.png

    Again, your help is much appreciated. If you can point me to any learning resources, I am much appreciative.

    WC

  • Unknown geen idee Profile Picture
    1,755 on 26 May 2023 at 07:49:41
    Re: Copying URL from Excel to a web page

    Dear W,

     

    It seems to me you are using PowerAutomate Desktop, rather than PowerAutomate. So you may want to move/copy your question in the right forum to ensure you get a right response.

     

    Having said this, why are you using PowerAutomate Desktop, my advice is that you try and keep as much as possible to PowerAutomate (cloud) as this is in my experience far more versatile. Only when there is no other way, use PAD.

     

    If you must use PAD ... if you copy your flow (blacking sensitive data), I may be able to have a look and guide you along.

     

    Happy flowing,

    Koen

     

     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 349 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 271 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 263

Overall leaderboard
Loading started