Skip to main content

Notifications

Community site session details

Community site session details

Session Id : +tvCZggQ6MzdOrxKsXBXbj
Power Automate - Building Flows
Answered

Extract data from an HTML table

Like (0) ShareShare
ReportReport
Posted on 22 Aug 2023 15:16:34 by 37

Good day,

 

I've done so much searching and tried different approaches but haven't figured this out and I'm hoping that someone can point me in the right direction or offer some advice.

 

Currently I receive a daily email that has, amongst other text, a large table that contains information that I need.  But it also includes information for other site locations that I don't need and makes the table hard to read and easy to miss the relevant information.  The table currently has a fixed number of columns, but the number of rows can change.

 

What I want to do is take that table and extract only rows where one of the columns contains specific text (our site location).  I can then use that to create a new table with only that information.  That will allow us to see only the information that I need and not all the other items.

 

Right now, I can get the table extracted from the original message as another HTML table.  I can also extract it as plain text, too, but it's all one very long line.  I was thinking that I could put it all into an array and manipulate it from there but I can't find any informaiton on how to do that.

 

Does anyone have any thoughts on this?

  • Verified answer
    jmarinuk Profile Picture
    37 on 23 Aug 2023 at 17:30:23
    Re: Extract data from an HTML table

    Just to update, I got this working. Between a combination of a method to extract the HTML table (Parse data from an HTML table in an email with Power Automate (tomriha.com)) and the video that Koen5 referenced, I got it running. It takes a lot of steps and I feel like it can probably be cleaned up eventually but it's working.

  • jmarinuk Profile Picture
    37 on 23 Aug 2023 at 11:51:22
    Re: Extract data from an HTML table

    Thank you.  I was actually just about halfway through that video.  It was starting to look like it wouldn't do what I needed but, knowing that it mostly worked for you, I will keep going.  

  • Unknown geen idee Profile Picture
    1,755 on 23 Aug 2023 at 11:16:36
    Re: Extract data from an HTML table

    Dear J,

    I have encountered the same problem and there are several options, either from HTML or plain text or csv to end up with a practical array. In the end I followed (most of) the instructions in the instruction video: https://www.youtube.com/watch?v=IwRKWaTnl3U

     

    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,765 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started
Loading complete