News and Announcements icon

Power Platform CommunityForums Power Automate - Power Automate Desktop XML xpath expression t...

Power Automate - Power Automate Desktop

Unanswered

XML xpath expression to get sum

Like (0) Share

Report

Report

Posted on 6 Apr 2021 14:13:40 by Aditya_93

37

Hi Team,

I have been trying to execute an XPath expression in order to get the sum of a few nodes but it returns an "invalid XPath expression"

Below is the sample xml

"<Xavor>

<Dev>

<NewNode1>1234</NewNode1>
<Emp>1</Emp>
<Floor>1</Floor>
<Salary>1200.4</Salary>

</Dev>

<Dev>

<NewNode1>1234</NewNode1>
<Emp>123</Emp>
<Salary>3</Salary>

</Dev>

<Dev>

<NewNode1>1234</NewNode1>
<Emp>3</Emp>
<Salary>1000</Salary>
<Floor>1</Floor>

</Dev>

<Dev>

<NewNode1>1234</NewNode1>
<Emp>4</Emp>
<Salary>3</Salary>

</Dev>

</Xavor>"

Xpath query expression I have used:- SUM(Xavor/Dev/Salary)

Please help to correct any syntax I have missed.

Thanks

Aditya

Categories:

Process Advisor

All responses Img

All responses (3)

Answers Img

Answers (0)

fraenK 2,125 on 07 Apr 2021 at 06:53:03

Like (0)

Report

Re: XML xpath expression to get sum

Please post the full error message!

It seems like PAD only supports retrieving nodes and its attribute values, not calculated values.
So you need to get all desired node values first as a list and then process this list for calculation.
Aditya_93 37 on 07 Apr 2021 at 05:30:06

Like (0)

Report

Re: XML xpath expression to get sum

I have tried the above path expression, but it's still giving me error as "invalid XPath expression"
Can you please help me?
yoko2020 495 on 06 Apr 2021 at 17:29:55

Like (0)

Report

Re: XML xpath expression to get sum

Try this

sum(/*/Dev/Salary[string(number(.)) != 'NaN'])

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,670 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts

List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans