Outlook 365 XML Attachment to SQL Server

Hi

I'm hoping someone here has tried to do this from an Outlook365 mailbox.

I get emails from a parts supplier with 2 attachments: a pdf and an xml document.

With our old Mailparser setup we extracted the XML into a string and stored it in a nvarchar(max) column on SQL server.

I'd like to replicate this process in Flow. So far I can process new emails, conditionally grab the XML attachment and send either an MS Graph object or a binary content and put that in the table (in a varbinary column).

As far as I can tell I cannot find a method to merely read the text of the XML file attachment and dump that to a column.

I don't wish to parse the XML in a more detailed fashion in the Flow itself as this process is thoroughly setup on SQL Server plus we do need to keep the XML string for future queries.

What I have so far is:

Login to the mail box, process new emails as they land
For each attachment, conditionally check, does it end in XML
If yes, insert row to a SQL Server, filling in various fields.

Any advice would be gratefully received. At the moment, as this query hasn't yielded to Google fu, I'm looking at whether we can unpack the binary data from the attachment instead - though this feels like the long way round and not quite right.

Thank you for your time if you are able to suggest anything.

Quick Links

Leaderboard > Power Automate