Skip to content

How to create XML from SQL select query?

I was building integration and was required to create an XML file as end result. I found out that you are able to generate XML formatted results based on SQL query just a simple addition to the query itself:

image-5.png

I’m using this kind of statement in Power Automate’s execute SQL Query -action and then just saving the outcome as an XML file in SharePoint. 

I found the article below useful, and there’s nicely explained all the other stuff that you can do with SQL and XML. 

Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *