Unanswered

Extract Column name and Its Corresponding Value from the Web Extracted Value

(0) Share

Report

Posted on by Rajesh_G

Extract Column name and Its Corresponding Value from the Web Extracted Value

Hello Everyone,

I am trying to extract data from a website using Extract Data from web page action. But I got this using Extract as HTML Table.

But the problem is the row 1 is the header name and it's value dynamic. I want to get the header and its corresponding value in the EPS row.

Example: Jun-23 - -0.58

Mar-23 - -0.41
Fy22-23 - -5.68

In some scenario instead of Jun-23 there will be value like Sep-23 or the Field maybe interchange

I've tried myself but am at a loss.

Hope to get some help on this!

Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Rajesh_G

So you want a final datatable that should have headers like Jun-23, Aug-23 like that with values in EPS row corresponding to each ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Rajesh_G 45 on at

Like (0)

Report
Copy link

Link copied!

Yes, Exactly @Nived_Nambiar

Was this reply helpful? Yes No
Rajesh_G 45 on at

Like (0)

Report
Copy link

Link copied!

Hello @Nived_Nambiar

This is the website Where I extract Values : https://www.bseindia.com/stock-share-price/alkem-laboratories-ltd/alkem/539523/

And the table look like this

As I mentioned earlier the Sep-23, Jun-23 and FY22-23 Field s dynamic and based on that I have to get the corresponding EPS values.

Please let me know any other details you required.

Thanks.

Was this reply helpful? Yes No