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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
23 | |
17 | |
17 | |
13 |
User | Count |
---|---|
123 | |
34 | |
34 | |
28 | |
25 |