Answered

Count XML items

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

is there a way to count the number of items in Power Automate Desktop with xpath.
In my example I would like to know how many articles there are and then use this value for a loop.

<?xml version="1.0" encoding="ISO-8859-1"?>
<Messages>
 <Message>
 <MessageStandard>TESTXML</MessageStandard>
 <MessageType>8</MessageType>
 <Sender>Michael</Sender>
 <IsTestMessage>N</IsTestMessage>
 <Article>
 <LineNumber>0001</LineNumber>
 <ArticleDescription>Test-Article 1</ArticleDescription>
 </Article>
 <Article>
 <LineNumber>0002</LineNumber>
 <ArticleDescription>Test-Article 2</ArticleDescription>
 </Article>
 </Message>
 </Messages>

I already try it with a xpath expression.

count(//Article)

Thank you and best Regards

Cartis

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Cartis,

You will need to change the xPath query. In your case you want to count the <Article> so you can navigate like "Messages/Message/Article" as per your xml file and get the output using "XPathResults.Count". Please refer below for more details.

---------------------------------------
Thank you and hope it can help you.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kaif_Siddique,

Thank you very much.
I had no idea how simple it was.
You helped me a lot with this, thank you very much.

Best regards
Cartis

Was this reply helpful? Yes No