Selenium Xpath read and get value, then write to excel

(0) Share

Report

Posted on by Learnjaya

HI team,

Thank you for your wonderful support.

I am using for the Power automate destop Program. This program supports what we created for the new project and writes web page elements to capture, then writes to Excel. I have doubts about this project program and would like to explain the flow chart as below:.

1. Read excel

2. excel converts to a datatable

3. Select a particular URL link from the Excel file.

4. Open browser for that links

5. then capture value from webpage support for Xpath value (Xpath read to excel file).

6. Capture the value and write it to Excel.

7. final, output file save to location path.

Thank you,

Jaya

Categories:

Power Automate Desktop

I have the same question (0)

All responses (12)

Answers (0)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Learnjaya

The above flow looks fine, but I doubt selenium xpath support by power automate desktop.

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
Learnjaya 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Thank you for support reply,

I have multiple issuer weblinks, and capture of the "Share Outstanding" Price for every issuer site.

Please see the screenshot below.

Now, you can understood of the xpath details.

Thank you
Jaya

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Learnjaya

Only the way forward is, just use JavaScript where you will pass xpath as input and it will extract the data from specific parameter and give your number as output. I tried with help of chatgpt, its working fine.

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
Learnjaya 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your wonderful support,

Would you please share your instructions for the Javascript where you put it in the Power flow chart?

Thanks
Jaya

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Learnjaya

Try something like this:

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
cwischnewski 162 on at

Like
a
(1)

Report
Copy link

Link copied!

Power Automate doesn't use Xpath, instead it uses CSS Selectors plus some jQuery. This is closely related to Xpath but different. There isn't a 1 to 1 feature but I have found more power in the jQuery functions. My two go-to references to translate Xpath to jQuery is:

https://devhints.io/xpath A great cheatsheet that gives a good idea of the feature you might google for.

https://api.jquery.com/category/selectors/ Is good documentation for jQuery functions that I find pretty well work as documented in PAD. One thing to note, using Chrome's dev tools you can test and verify both Xpath and CSS Selectors, but typically when jQuery functions get added to the selector, the Chrome element browser stops working. So the testing is best done inside of PAD.

Was this reply helpful? Yes No
cwischnewski 162 on at

Like
a
(1)

Report
Copy link

Link copied!

Just a quick example:
Xpath:
//td[contains(text(),'Something here')]

CSS+jQuery
td:contains('Something here')

Was this reply helpful? Yes No
Learnjaya 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi team,
Great support and effect for this issue solution. I will check for your instruction steps and update for soon.

Once again thanks for support.
Jaya

Was this reply helpful? Yes No
Learnjaya 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Team,
I am trying to prepare and execute for jQuery Xapth with the issuer link process done. But I have a small doubt. I have multiple issuer links in Excel, and please see the screenshot in the previous email above. Now we are facing an issue with the program reading the Excel "URL" link open to navigate the browser and getting an error. Please see the screenshot for your reference.

Thanks,
Jaya

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

Like
a
(1)

Report
Copy link

Link copied!

Seems like you are referencing the CurrentItems URL column wrong. Do it like this:
%CurrentItem['URL']%

NOT like this: %CurrentItem%['URL']
If you have the column outside the percent signs it will take the whole current item data row and add the ['URL'] as a string to the end.

Like this:

Was this reply helpful? Yes No