Hello Everyone,
I am working on a requirement that, to fetch XML file from ADO through power automate and splitting the file and showing it in my app like control values. For this I am using "send an HTTP request to DevOps" in my flow. Following the same process for push back the changes to DevOps ADO. By doing this, I need to do the following as well,
1. Add new node to the XML,
2. Delete the existing node,
3. Updating the node
Currently, I am achieving adding new node with multiple steps. But, for updating or deleting excising node should happen based on the key. So, I would like to know that is there any simplified way to achieve this.
This is my example XML:
<?xml version="1.0" encoding="utf-8"?>
<root>
<data name="KEY_1" xml:space="preserve">
<value>value 1</value>
<comment>comment 1</comment>
</data>
<data name="KEY_2" xml:space="preserve">
<value>value 2</value>
<comment>comment 2</comment>
</data>
<data name="KEY_3" xml:space="preserve">
<value>value 3</value>
<comment>comment 3</comment>
</data>
<data name="KEY_4" xml:space="preserve">
<value>value 4</value>
<comment>comment 4</comment>
</data>
</root>
1) Add a new node with key "KEY_5" and value "value 5"
2) Delete the data node with key "KEY_2"
3) Update the value of the node with key "KEY_1" with value "value 1 new" – Whenever I’m trying to update the value I must find the respective key and update the value.