Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 7e8kRuWaTAQ2IcMzZ2MxOH
Power Automate - Power Automate Desktop
Answered

Need Help Web Scraping Values from a Single Page

Like (0) ShareShare
ReportReport
Posted on 12 Sep 2023 12:13:32 by 5

I am trying to Web scrape data from over a hundred pages, Each page contains data for one full record. However, PA treats each data piece as a row, and I need it to be a column (value). I'm saving to Excel. Please help.

Screenshot 2023-09-12 070025.pngScreenshot 2023-09-12 065924.png

  • kelliadam Profile Picture
    5 on 13 Sep 2023 at 00:01:49
    Re: Need Help Web Scraping Values from a Single Page

    Thank you! It worked perfectly.

  • Verified answer
    Agnius Bartninkas Profile Picture
    10,045 Most Valuable Professional on 12 Sep 2023 at 12:19:44
    Re: Need Help Web Scraping Values from a Single Page

    Click on the "Advanced settings" button in the extraction preview. Then make it extract "Handpicked values" instead of a table.

    Agnius_0-1694521142345.png

     

    When you do that, you can specify a CSS selector for each value you want and the result will be a data row of handpicked values. When you have multiple pages, you'll get multiple rows.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

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 - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 119 Super User 2025 Season 1

#2
CU12050101-0 Profile Picture

CU12050101-0 26

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 20 Super User 2025 Season 1

Overall leaderboard
Loading started