send an HTTP request to DevOps - To find XML node to ADD/UPDATE/DELETE node

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.

Quick Links

Leaderboard > Power Automate