Happy New Year readers !! Hope you all are doing well. In today’s article, we will see how to use XML Node in Power Automate Desktop. You can refer to this link to glance through the previous articles on PAD. So let’s begin with how to use XML Node in PAD. We will see below the actions of the XML node.
1. Read XML from file
2. Write XML to file
3. Execute XPath expression
This action read the contents of an XML file into a variable. Before proceeding to this step we will create a sample XML file as shown below. The file name is BooksDetails. Refer to this W3Schools site for more examples.
<?xml version="1.0" encoding="UTF-8"?> <bookstore> <book> <title lang="en">Harry Potter</title> <price>29.99</price> </book> <book> <title lang="en">Learning XML</title> <price>39.95</price> </book> <book> <title lang="en">Flexmind AZ-400</title> <price>49.95</price> </book> </bookstore>
Select the parameters for the read xml file action. Here I have kept the default encoding. You can select depending on your XML file.
Extract values from an XML document based on the provided Xpath query. We will drag this action below the read xml action.
XML document to parse: Pass the variable which collects the XML file data. Here in this case this value is %XmlDocument%.
XPath query: /bookstore/book/title. Please refer to this link for more details on the XPath query. I am also not very good at writing XPath queries. 🙂 Therefore I have taken a simple one to demonstrate this example. /bookstore/book/title, fetches title of the third book of bookstore node.
Now we will display this action in a display message box to show the result.
After completing the above steps, run the flow. It will display message like below.
Write the contents of an XML node variable into a file. We can use this action to write an XML file. Refer to the below image for parameters. You can see the below example, I have updated the code from Flexmind AZ-400 to Flexmind PowerApps.
Now run the flow, it will update the whole XML file.
Hope you all will like this article on how to use XML Node in PAD (Power Automate Desktop). In our upcoming article, we will discuss the other XML actions of PAD. Stay tuned !!