Power Community

Power Community

One Minute Fixes – Summing up a field

There is an unlikely expression that can sum up any field/key in an array, and that’s the XPATH expression. The XPATH allows you to sum up any level of the array, it does require the json array to be converted to xml, but we have the XML expression for that.

The whole process is 3 steps

  1. ‘Select’ to create and array of the numbers,
  2. ‘Compose’ to create a xml compliant object (root/fieldName).
  3. And finally a ‘Compose’ / ‘Set_variable’ to store the sum in by converting it to an xml and using xpath.

wyattdave_1-1709244270674.png

The final expression converts the object into XML and then uses the XPATH expression.

xpath(xml(outputs('ComposeConvert')), 'sum(/root/number)')

Xpath can do Min,Max,Average,Count as well as Sum. It can also use And/Or operators to filter cross fields, and much more.

>———————————————————————————————————————————————-
This is a series of short blogs designed to help find solutions for random problems before you ask, keep your eyes out for more

l also do long form and broader Power Platform blogs here https://dev.to/wyattdave

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

5 Benefits of In-App Notifications for Microsoft Dynamics 365 CRM users

For a successful sales process, you need to stay up-to-date with crucial sales information like deal closures, opportunities won,...

More Articles Like This

- Advertisement -spot_img