Unanswered

Extracting XML values to array

(0) Share

Report

Posted on by BernatP

Hello, I need some help understanding how to extract the values on a list for <string>

<ModelLab>
 <Subtype>1</Subtype>
 <Symmetry>1</Symmetry>
 <Compatible>
 <string>HELLO
 </string>
 <string>HELLO2
 </string>
 <string>HELLO3
 </string>
 </Compatible>
<ModelLab>
 <Subtype>2</Subtype>
 <Symmetry>2</Symmetry>
 <Compatible>
 <string>HELLO4
 </string>
 <string>HELLO5
 </string>
 <string>HELLO6
 </string>
 </Compatible

Actually I'm using Obtain value of XML element with XPath "//ModelLabA/Compatible/string" but it only returns me one line.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

NathanAlvares24 1,714 Moderator on at

Like (2)

Report
Hi @BernatP !

I am assuming your XML is this as there is lot of missing data like I am not sure where is ModelLabA, I can see only ModelLab:

<Root> <ModelLab> <Subtype>1</Subtype> <Symmetry>1</Symmetry> <Compatible> <string>HELLO</string> <string>HELLO2</string> <string>HELLO3</string> </Compatible> </ModelLab> <ModelLab> <Subtype>2</Subtype> <Symmetry>2</Symmetry> <Compatible> <string>HELLO4</string> <string>HELLO5</string> <string>HELLO6</string> </Compatible> </ModelLab> </Root>

Try this flow:

I have stored this in an xml file on my machine and then I am reading from this as seen in actions 2 and 3.

Output:

Code (copy and paste this onto your flow):

Variables.CreateNewList List=> ListofStrings SET pathXML TO $'''C:\\Users\\testing.xml''' XML.ReadFromFile File: pathXML Encoding: XML.FileEncoding.DefaultEncoding XmlDocument=> XmlDocument XML.ExecuteXPathQuery.ExecuteXPath XmlDocument: XmlDocument XPathQuery: $'''Root/ModelLab/Compatible/string''' XPathResults=> XPathResults LOOP FOREACH CurrentItem IN XPathResults XML.GetXmlElementValue.GetElementValue Document: CurrentItem TextValue=> XmlElementValue Variables.AddItemToList Item: XmlElementValue List: ListofStrings END

I hope this helps.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@BernatP

Please describe your complete use case and provide some sample XML data, ensuring all sensitive information is obscured.

From the XML data provided, it appears that there are no elements named "ModelLabA" or "ModelLabB," yet you are attempting to extract them.

Therefore, please furnish more context and sample data so that further assistance can be offered on this matter.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
BernatP on at

Like (1)

Report

Hello and thaks for the quick reply!
It worked perfectlly and helped me so much to build the flow. Also I noticed that when I created the flow I did with the Power Fx activated and with that mode I can't see all the nodes.

Now all works perfect. Thanks again.

Was this reply helpful? Yes No