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?
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.
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.
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
WarrenBelz
146,765
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional