cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KJSawyer
New Member

Extract attribute/value pairs from meta tags in HTML body of email that arrives in O365 shared mailbox then inject into table in Excel saved in 365 Sharepoint

The subject pretty much says it all. I have emails arriving in a shared mailbox in O365. They contain HTML which includes several attribute/value pairs as meta tags similar to this:

 

    <meta name="blah1" content="Jenny">
    <meta name="blah2" content="8675309">
    <meta name="blah3" content="Peas and Carrots">
    <meta name="blah4" content="Forrest">

As messages arrive, I need to extract these attribute/value pairs then inject them as a new row into a table in Excel stored in SharePoint 365 whereby the attribute names correlate with the column names. Bonus points if a new column is automatically created if/when a previously unseen attribute is detected.

 

I know how to trigger the automated flow based on the new message arriving in the shared mailbox. I know how to pull in the body of the message. But I'm not sure what tool/function to use to find the meta data and shove it into a new table row in Excel. I've searched here and found a few things that are close, but not quite close enough to fill in my knowledge gaps.

 

Thanks in advance for your tips and hints!

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,708)