Unanswered

Referencing multiple URLs from Excel sheet

(0) Share

Report

Posted on by AmsterCam

I have a list of URLs in an Excel sheet (cells E2:E35).
All of these URLs are already opened in my Edge browser.
I need to get PAD to attach to each of the URLs (in the same order they are listed in Excel) and retreive data from each URL and write that data back to the Excel sheet on a seperate column.
How can I get the "Attach to Microsoft Edge tab with URL (or title)" to reference each of the 34 different URLs shown in the Excel list?
Please note that I would prefer to reference the URLs or titles directly, not use "Send Keys" to change browser tabs etc (because the browser tabs may sometimes be open in a different order vs the Excel list).

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@AmsterCam

It appears that you forgot to attach your Excel file. However, based on the screenshot provided, it seems you have correctly created your flow.

I've replicated the process on my end for your reference. Could you please elaborate if you are encountering any issues with this approach?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
AmsterCam 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deenuji,
It keeps giving the attached error, cannot get the URLs to work.

Was this reply helpful? Yes No
eetuRobo 4,574 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

I think its because your ExcelData is a datatable. If it was a list you could refer to it like so but since your CurrentItem is not an list item but datarow you need to refer to it as %CurrentItem[0]%
So change your Edge attach to %CurrentItem[0]%

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@AmsterCam
If possible could you please share some example what url did you open with edge and how it look like the same url in for each current item?

Meanwhile try the below example.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@AmsterCam

As @eetuRobo rightly pointed out. Please check your datatable and mention the right syntax while attached the url to browser.

If URL is first column try something like --> %CurrentItem[0]% or something like %CurrentItem['URL']%

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
AmsterCam 20 on at

Like
a
(0)

Report
Copy link

Link copied!

As I am dealing with sensitive data, please understand i cannot share the Excel or URL.
When I tried to attach to the URL using %CurrentItem[0]% as @eetuRobo suggested, it successfully pulls the data from the 1st URL and writes it into the Excel sheet. However for the 2nd URL it doesnt work, says "Failed to retreive attribute "Own Text" of UI element on web page".
I'm thinking this might be because I set the UI Element using the first URL, then used this UI Element (in the loop) for all URLs. I want to access the exact same information (UI Element) on each tab browser, which is the same website opened using a different account/profile but showing the same kind of info. How to solve this?
FYI my list of URLs is contained in column E of my spreadsheet (cells E2:E35)

Was this reply helpful? Yes No
eetuRobo 4,574 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Then you need to edit the UI elements to work with different sites/instances.
So since the site is same but with different accounts your parent/window element should be same. But you should double check that
Open that and check that it doesn't refer to the specific url from your excel list or the account it is logged in as in that site since that changes every loop.

So for example in my picture:
If we assume you would be automating this site with different accounts you would not want to refer to the text "About eetuRobo" since we imagine that it would be different account every loop.
So either you would change the operator to "Starts with" and remove the "eetuRobo" or you would toggle on different attribute to specify this element.
So go through your elements and check that they are not trying to refer to elements that specifies the first account but works with all of them.

Was this reply helpful? Yes No
AmsterCam 20 on at

Like
a
(0)

Report
Copy link

Link copied!

I understand all you wrote and it seems that my problem is caused by the UI elements referencing the Same URL of the 1st URL in my list.
I cannot solve it as you illustrated.
My URLs are all consisting of the same format:
"Website general URL/" + "Account number" (the account number is different for each URL).
However, the Website general URL does not work without an account number, it will instead appear as a screen where you need to enter your account number, then hit enter to go to the destination URL I'm trying to access.

In the UI Elements, the individual account number of the first URL is deeply embedded in the overall website and in the individual UI Elements. I cannot edit this the way you showed me, the options all look different and much more complex. I'm Stuck.

Was this reply helpful? Yes No
eetuRobo 4,574 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you put the account number on a variable inside your for each loop and then use that variable inside the UI elements.
Like so:

If you can please share a screenshot of your UI elements so its easier to understand and give guidance (You can draw over the url or other sensitive info)

Was this reply helpful? Yes No
AmsterCam 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@eetuRobo I dont understand what is the difference between all the reference numbers 14, 15, 16 etc (in your image. My one also has many numbers like that).
Ok here are some screenshots with sensitive data hidden as follows:
RED: Website genral URL info
BLACK: Account number specific info
GREY: Other (like names I applied to the UI Elements)

Was this reply helpful? Yes No